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?
It does not matter if your cell contains a function, the result should be used in calculating the sum. As JMB17 noted, perhaps your numbers are being stored as text values. Examine the different in results of the following example:
An example of your formula would surely be helpful.