Countifs result not matching filter

In my sheet, I have a filter for 2 values (see below images). The result is 294

In my report this formula yields 304.

=COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid")

Why are they not matching? What am I missing?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Is the Status column a multi-select or no?

KimTDSYN

Yes, multi-select.

Do I need to use Not(contains())….?

DKazatsky2

Hi @KimTDSYN,

Give this a try.

=COUNTIFS({helper-child}, "1", {gapStatus}, AND(NOT(HAS(@cell , "Rejected (not a GAP)")), NOT(HAS(@cell , "removed - duplicate")), NOT(HAS(@cell , "removed - not valid"))))

Hope this helps,

Dave

KimTDSYN

That worked!

Thank you.

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.