COUNTIFS not working where one reference is a column with multiple drop downs...

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, "CASI")

This isn't working... I want a count for if the Priority is Critical (this is in [Column2]$28) and the Platform (from a drop down column) includes CASI. (There may be multiple entries in the drop down column). I know the answer is 1 but it's not returning that number...

HELP!!! Going mad here... 🤔

Find more posts tagged with

Accepted answers

Paul Newcome

If you are using a multi-select dropdown, you will want to include a HAS function like so:

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, "CASI"))

All comments

Paul Newcome

If you are using a multi-select dropdown, you will want to include a HAS function like so:

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, "CASI"))

nualamcd

Awesome! Do I have to type each platform name or can I use a Column1@row code?

Paul Newcome

You can use cell references, but keep in mind that column names that have a special character, number, and/or space need to be wrapped in [square brackets].

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, [Column1]@row))

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, [Column Name]@row))

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, ColumnName@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.