Countif w/ multi drop down

Hi,

I have a list of drop down items:

I am trying to total the amount of those selected on another sheet. (How many rows contain those three items bundled together). I am getting an error message when I try:

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, "FMLA" AND "CFRA" AND "Wave Parental Leave")

What am I missing?

Thanks! :)

Find more posts tagged with

Accepted answers

Mark Cronk

I goofed the syntax. Try:

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA"), HAS(@cell,"CFRA"), HAS(@cell,"Wave Parental Leave")))

Work this time?

Mark

All comments

Mark Cronk

Try:

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, HAS(@cell, AND("FMLA", "CFRA", "Wave Parental Leave"))

The HAS function return true if the multiselect cell has the exact content and false if not.

Work?

Mark

Jordan Ionita

Hi Mark,

It is showing as 0, even though there are those combinations...

Mark Cronk

I goofed the syntax. Try:

=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA"), HAS(@cell,"CFRA"), HAS(@cell,"Wave Parental Leave")))

Work this time?

Mark

Jordan Ionita

Yay this worked! Thank you!!!

Mark Cronk

Excellent. Glad you found a solution. Please accept an answer to close the discussion. Thank you for contributing to the Community.

Mark

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.