sum formula equals zero

[Guest]

I am working in Excel and when I use the sum function I get zero. My cell
format is number, my calculation is automatic. I cleared by cell contents
and typed
=sum(G2:G25) and I get 0 every time. My answer should be 575. I also get
a green triangle in the left hand corner. Is there a box that should be
checked or uncheckd in tools-options.

 

[Guest]

Sounds like your cells contain text (and that's probably what the green
triangle is telling you). To force the numeric strings to be converted to
numbers, type a 0 in any random cell, then copy that cell (ctrl+C). Select
your range (G2:G25), then edit / paste special, select the radio buttons for
'values' and 'add'.

(An easy check to see that your numbers really are being treated that way is
to select them, then click on one of your numeric style buttons (comma,
percent). If they're really numbers, the formats will change.)

 

[Niek Otten]

Your cells are text, not numbers. That's what the green triangle tries to
get your attention for, as you will see if you select such a cell and click
the exclamation mark

Format an empty cell as Number, enter the number 1 and copy.
Select G2:G25, Paste Special, check Multiply.

Make sure any other cell you want to be numbers are formatted as such before
you enter the number.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel