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 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?
3 Replies
I resolved this issue, which I had it recently. it occurred for me in two cases 1) if a cell with subtotal() function is referred in the sum() 2) if a sum() function with the domain/argument is defined includes the cell where sum() function is. I resolved them to correct the root causes, which 1) don't refer to a cell with subtotal correct the sum() is has a range that includes its own cell, which you may write a composite, e.g. summation of sum() functions that spans separate ranges.
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/problem-with-sumif-formula/td-p/3970460
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.
