Count criteria in multi-select dropdown

Is there an edit (or alternate formula) to the 'COUNTIFS' formula I'm using to count all instances of a particular criteria whether or not its included in a dropdown list on its own or listed among other criteria?

As an example, the formula currently show is only counting instances of "SRC" when it's the only criteria in the cell, and not counting it when it's listed with other criteria (e.g. ALA, Germany, etc.). I need the formula to count all cells with "SRC" in the column whether or not it's listed alone or with others. I hope that makes sense. Thanks for the help!

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Hi @Shane Sorensen ,

Try:

=COUNTIF([business vertical]11:[business vertical]118, HAS(@cell, "SRC"))

The HAS function looks into multi-item cells and returns true if it finds a match.

Work for you?

Mark

All comments

Mark Cronk

Hi @Shane Sorensen ,

Try:

=COUNTIF([business vertical]11:[business vertical]118, HAS(@cell, "SRC"))

The HAS function looks into multi-item cells and returns true if it finds a match.

Work for you?

Mark

MrDramaFree

Thank you @Mark Cronk, this perfectly worked!

Shane

Mark Cronk

Happy to help. Thank to for using the Community.

Be Well,

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