Sep 17 2020 07:15 AM
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?
Sep 17 2020 07:25 AM
Sep 17 2020 07:55 AM
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)
Sep 17 2020 08:56 AM - edited Sep 17 2020 08:57 AM
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.
Sep 17 2020 09:17 AM
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.