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!)
Help Article Resources
Check out the Formula Handbook template!