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

[Jennifre]

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.

 

[Firefly2012]

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

 

[Norie]

Does the SUM work on it's own?

 

[Jonmo1]

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
	E	F	G
30	8	65	520
31	2	65	130
32	3	65	195
33	76	65	4940
34	5	65	325
35
36	6110		6110
Sheet1

 

[Jennifre]

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!

 

[Jennifre]

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!

 

[Firefly2012]

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

 

[Jennifre]

.

 

[Jonmo1]

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

 

[Jennifre]

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?