Sum is giving the wrong answer when adding values generated by "countifs" formula

Pam Grant

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!)

Pam Grant

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.

Pam Grant

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.

Barry Holt

This happens a lot for me, but is resolved by either refresh or close and re-open the sheet. I have a good-sized sheet with lots of references so not sure if that plays a part.