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

"shathun" wrote in message
...
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.