CONTAINS COUNTIFS from Multi-Select Drop-Down

Hello,

I've had this issue before, but forget how I've solved it. I have a formula that is trying to count an option in a multi-select menu, it cannot be a simply COUNTIFS statement and must use CONTAINS or HAS since there is more text in the cell then just one word.

Here is my formula, which is appears the syntax is correct, but it is not counting. Can somebody please let me know where I've gone wrong? Thank you!

=COUNTIFS({NPI Impediments}, CONTAINS([Schedule Change]$1, {NPI Impediments}), {Project}, $[Domain For Impediment]6)

Screen Shot 2022-06-22 at 10.50.07 AM.png

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Change the {Range} within the CONTAINS function to an @cell reference.

RingJake

Hi Paul,

Could you please provide the syntax? Not sure exactly how to add it?

Paul Newcome

Change

{NPI Impediments}

within the CONTAINS function to

@cell

RingJake

Great, thanks Paul! I really don't understand the @cell function too well, which leads to confusion.

Paul Newcome

@cell just tells the function to evaluate the previously established range on a cell by cell basis.

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.