Countif status is "In Work" and Multiple choice contains

Hello All,

I am trying to establish a Countifs formula that first checks status, then looks for a specific multiple choice option. Is this possible?

=COUNTIFS({AD-CVT Disc Status}, "In Work"), ({Above Findings}, (CONTAINS(Primary Column]@row, @cell))

Any help is appreciated! Thank you.

Find more posts tagged with

Accepted answers

All comments

Leibel S

@WldAcrUsa

This should work, you do have a some extra parentheses:

=COUNTIFS({AD-CVT Disc Status}, "In Work", {Above Findings}, CONTAINS(Primary Column]@row, @cell))

WldAcrUsa

Here is the final formula I used.

=COUNTIFS({AD-CVT Disc Status}, "In Work", {AD-CVT Discrepancy Tracking Range 3}, HAS(@cell, [Primary Column]@row))

Paul Newcome

The original formula had an issue with the parenthesis as @Leibel Shuchat pointed out as well as a missing opening square bracket before Primary Column]@row.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.