Forum Discussion
SUM not working when referencing cells of formula output
Hey there - so I am trying to use the SUM function to sum together a group of cells. These cells are outputs from an IF formula referencing another cell. The SUM function is giving 0.0 even when the ...
Make sure that the formulas return a number such as 1 or 2, not a text string such as "1" or "2".
The SUM function ignores text values.