Countifs calculation get wrong number

LTH

Hi,

I use a metrics table to calculate how many items in CNPA summary table.

I want to calculate how many "Basic information" in Request Items column in CNPA summary table.

The formula I used in metric table is

COUNTIFS({Request Items},"Basic Information(location, die size…)")

It returns 80. However, there are only 71.

How could I modify the formula?

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/142074/countifs-calculation-get-wrong-number

Hi,

I hope you're well and safe!

Have you checked the whole sheet and removed or added a filter to double-check?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

LTH

Hi Andrée Starå,

I've tried filter and removed filter, even reselect the reference.

The counts are always 80.

Please refer to the attachment. Without filter, there are 196 counts. Fiter Application Date > 2025/4/1, there are 71 counts. I don't know how 80 comes from.

Is there anything I missed?

Smartsheet_CNPA Summary.xlsx

LTH

Hi Andrée Starå,

I know what's going on.

What I want is to count how many "Basic Information(location, die size…)" appears in Request Items column.

The original is COUNTIFS({Request Items},"Basic Information(location, die size…)").

I correct it to COUNTIF({Request Items}, CONTAINS("Basic information (location. die size...)", @cell )) and it's OK now.

However, there is a problem. The number wouldn't be updated if I filter the raw data. Is there any way to count the number with fiter?

Thanks

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.