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?
You can use SumProduct. For example you want to calculate values that are above zero in range A1:A10
=SUMPRODUCT(--(A1:A10>0);A1:A10)