Forum Discussion

Copper Contributor

Nov 01, 2023

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 ...

excel

Patrick2788

Silver Contributor

Nov 02, 2023

ablackwell1205

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

https://techcommunity.microsoft.com/t5/excel/problem-with-sumif-formula/td-p/3970460