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.)
"shathun" wrote:
> 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.
Bookmarks