Sum formulas

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
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sum cells that have values from a text formula? 4
Excel formula, sum the value cell and if empty cell left blank 0
Making an excel sheet so formulas can not be deleted in the sum to 2
Sum of cells, where there are not errors in them 8
Need Help with "SUM" AND "ABS" in same formula 12
Select a range not equal to: 4
Use & with two formulas 2
Automatic update to SUM formula cell references. 6

Top