AutoSum

[De]

Trying to total up a column using AutoSum and the total
is not coming out. It just states 0.00

The cells that I am trying to total have if statements
written in them, would that cause it to not autoSum

Please help.

 

[Dave Peterson]

Do your if statements look like:
=if(a1="hi there","1234","4234")

if they do, then you need to get rid of the double quotes:
=if(a1="hi there",1234,4234)
so that the values are really numeric.

If your formulas refer to other cells that may have "text numbers", you should
clean them up.

copy an empty cell
select the original offending range
Edit|paste special|Check Add under operation.

====
And you don't have Tools|Options|calculation tab|Manual calculation, do you?