Sum is giving the wrong answer when adding values generated by "countifs" formula
I used Countifs to generate 4 numbers. I've validated these are correct with the data.
I want to Sum these 4 numbers to get a total but it gives me the wrong answer. It should be 407.
Why doesn't smartsheet give me the answer of 407?
My formula in the Sum Total cell is =SUM([Total # Facilities]9:[Total # Facilities]12)
(I'm thoroughly confounded on a Friday afternoon!)
Best Answer

OK  I'm really glad I included a screen shot because, otherwise, I would have looked like a complete lunatic.
My Smartsheet just refreshed and now the Sum Total is showing correctly! 🤪
Anyone else experience this? I was staring that the wrong number for a few hours.
Answers

OK  I'm really glad I included a screen shot because, otherwise, I would have looked like a complete lunatic.
My Smartsheet just refreshed and now the Sum Total is showing correctly! 🤪
Anyone else experience this? I was staring that the wrong number for a few hours.

This happens a lot for me, but is resolved by either refresh or close and reopen the sheet. I have a goodsized sheet with lots of references so not sure if that plays a part.
Help Article Resources
Categories
Check out the Formula Handbook template!