# Insanely dumb question... multiplying a sum of several cells

#### Jennifre

##### Board Regular
Sorry to be so... daft, but I can't use a formula to multiply one number by summed cells.

You'll be able to see what I was trying by this below, but it won't work. Putting the *65 inside the parenthesis didn't work either. I am slow to learn Excel's formula language.

=SUM(E30:E41)*65

Thanks so much for your help -- this site's forum is the best regarding questions I ask online, by far! Thank you.

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Hi Jennifre

That formula is how I would multiply the sum of E30:E41 by 65. Can you provide some sample data and state what result you would expect so we can understand what it is you want to do.

What result do you get that you don't want? Is it an error value (if so, are there any errors in E30:E41)?

Do you definitely have numeric values in E30:E41? Point an ISNUMBER formula at one of the cells to confirm eg:

=ISNUMBER(E30)

and report back the result

Does the SUM work on it's own?

Can you describe "it Won't work" ?
Do you get an error?
Do you get the wrong results? What result did you actually get, what result did you expect and why?

It seems to me that

(E30*65)+(E31*65)+(E32*65)
Yiels the same result as
SUM(E30:E31)*65

Excel Workbook
EFG
30865520
31265130
32365195
3376654940
34565325
35
3661106110
Sheet1

Sorry to be unclear. I've got this formula in my target cell, yet all that appears there upon hitting enter at the end of the formula, is the formula itself, not the result of E30:341 x 65.

The sum alone works as that's appearing successfully in a cell above the cell with this formula in it.

Thanks!

Sorry to be unclear. I've got this formula in my target cell, yet all that appears there upon hitting enter at the end of the formula, is the formula itself, not the result of E30:341 x 65.

The sum alone does work as it is appearing successfully in a cell above the cell with this formula in it.

Also, the =ISNUMBER(30) reports, "TRUE".

Thanks!

Last edited:
Is this cell formatted as Text? Right-click on it and choose Format Cells and ensure it is specified as General

Last edited:
.

Last edited:
Format the cell as General or Number (anything other than Text)
Then RE-Enter the formula

That worked, goodness! And, thank you so much.

Not sure why typing it out earlier would have rendered as anything but general. Is it recommended to normally format the entire sheet as general before you start?

Replies
9
Views
541
Replies
11
Views
639
Replies
12
Views
570
Replies
0
Views
183
Replies
2
Views
284

1,203,465
Messages
6,055,574
Members
444,799
Latest member
CraigCrowhurst

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back