Forum Discussion
How do I sum a column of IF formulas?
I am trying to sum the column of IF formulas but it's returning "0" since technically the column is filled with formulas, not actual numbers to calculate. Any suggestions?
If you can, upload an example of your workbook (if the data is not sensitive), or at least post an example of your IF formula. By chance, is your IF formula returning numbers that are actually text? For example, IF(condition, "1", "")? If the IF formulas are supposed to be returning numbers, then be sure the numbers within the formula don't have quotes around them. Also, for fields that are used in downstream mathematical operations, I like to return 0 instead of "" (you can always apply a custom number format to make the cell appear blank if it contains a zero to clean it up). IF(condition, 1, "") or IF(condition, 1, 0)