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

Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
Autonumber field in Excel that behaves the same as Access 0
Time Sum in Excel 1
Count Number of Unique Cells That Don't Have Certain Characters 0
dragging formula is giving me undesired result in cell calls. 0
Copy the content of a cell with Formula 1
Using =SUM...just can't figure this simple thing out... 2

Top