How to count rows with more than one selection in a drop down menu?

Hello you pros, I looked for an answer but was unsuccessful.

I have a column with a multi-select dropdown menu. The selections are for product categories in the cannabis industry (flower, edibles, concentrates, vapes etc)

I have found a working formula to count how many projects have a single category (thank you community!).

How do I count the projects that involve more than one category? I just want to report how many projects are multi-category no matter if they have 2,3 or 4 categories affected by the project scope.

Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

You would want something along the lines of...

=COUNTIFS({Range}, COUNTM(@cell) > 1)

All comments

Paul Newcome

You would want something along the lines of...

=COUNTIFS({Range}, COUNTM(@cell) > 1)

PMVie

That's it! Thanks Paul - I am nerding out and having so much fun with all this data. Woot woot!

Paul Newcome

Happy to help. 👍️

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.