SUM not working when referencing cells of formula output

Question

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 values are higher than 0. (see example below) I thought maybe it was that the cells were not formatted as numbers and excel was referencing them as text, but even when I change them to number format it still does not work. Can someone help?

hansvogelaar · Answer

ablackwell1205&nbsp;
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.

patrick2788 · Answer

ablackwell1205&nbsp;You've posted this question a few times. It may help if you reply to the help people are providing.https://techcommunity.microsoft.com/t5/excel/how-to-have-cells-sum-ed-even-if-a-cell-is-blank/td-p/3969276&nbsp;https://techcommunity.microsoft.com/t5/excel/problem-with-sumif-formula/td-p/3970460

Forum Discussion

SUM not working when referencing cells of formula output

Share

Resources