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.
the first formula returns text so sum formula cannot return any results.
You can check the attached file for a sample on how to use SumProduct wiht condition.