Adding cells to existing formula. I add 2 more cells and the total goes to "0" instead of updating

[Theresa Phillips]

Adding cells to existing formula.  I add 2 more cells and the total goes to "0" instead of updating total in cell.  Not sure what I am doing wrong.  Thanks.

[#2]

Theresa,

there is a change from the value before to 0.  So it is updating. Maybe not the updating you expected but still updating.

It could be a format issue.

[#3]

Hello,

can you post the formula you are using, and also post what the cells contain? It is hard to troubleshoot a formula without seeing either formula or data.

---