Forum Discussion
Solved
Sum Formulas
Hello, I have a simple spreadsheet that I want to use the SUM function. However, the cells I want to SUM have an IF formula in them already. When I use the SUM function, it returns zero. So how ...
CatherineMadden Your IF formulas return texts rather than numbers. That's why SUM returns zero. Remove all the quotation marks surrounding the ones and zeroes and the SUM function will work.
Having said that, I would recommend you to do away with those nested IF formulas all-together. The attached file contains an alternative method to achieve your goal.
Those cells, even if they have a formula, IF in your case, just add them as parameters to your SUM function, as you would any static value.
It will add whatever your IF function returns in those cells, whether it is 5 or 15, it will add whatever that cell gives.
I hope this helps.
It will add whatever your IF function returns in those cells, whether it is 5 or 15, it will add whatever that cell gives.
I hope this helps.