Sum formulas

  • Thread starter Thread starter Workin girl
  • Start date Start date
W

Workin girl

I have a form that needs to calculate several cells that have formulas in
them. I am needing to take the results of the formula which gives me a whole
number and sum them all together in another cell. It will not sum the cells
that have formulas in them. I need for the formula to stay in the cells.
Please help. Thanks for your help
 
In your formulas, remove any quotes from around any numbers.

WRONG:

=IF(A1="X","10","0")

Right:

=IF(A1="X",10,0)

Quoting numbers makes them TEXT and the SUM function ignores text.
 
Back
Top