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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.