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.

 

[Jonmo1]

Well I would say for whatever reason the cell was formatted as Text BEFORE you ever typed anything in it.
Typing the formula on it's own would not 'change' the format to Text.

That sounds like a good best practice, to format all cells of a new sheet as General first.
Then adjust formatting as required on individual cells/rows/columns.