How to COUNT multi-select drop down list.

My sheet is for process improvement ideas. When one is finished, we have a column where we can check off which areas we improved (some are just Cost Savings, some have 3 or 4 options selected).

I'm trying to count how many times each improvement category is checked off on the entire sheet. Note: I have 5 categories, for each of these attempted formulas I tried all of them in the " " to make sure it wasnt a spelling mistake or an unused category.

First Attempt: =COUNTIF({Areas Improved}, CONTAINS("Customer Experience", @cell)) which returned 0s for all categories

Second attempt: =COUNTM({Areas Improved}, CONTAINS("Customer Experience", @cell)) which returns 2s for all categories

Find more posts tagged with

Formulas

Accepted answers

Leibel S

If I understand correctly:

You have a multi select dropdown where you specify which area where improved within each improvement idea.

If that is correct, your first formula should work, although it would be better practice to use the HAS function for this setup, see below:

=COUNTIF({Areas Improved}, HAS(@cell,"Customer Experience"))

Check your cross sheet reference {Areas Improved} to make sure it is setup correctly

All comments

Leibel S

If I understand correctly:

You have a multi select dropdown where you specify which area where improved within each improvement idea.

If that is correct, your first formula should work, although it would be better practice to use the HAS function for this setup, see below:

=COUNTIF({Areas Improved}, HAS(@cell,"Customer Experience"))

Check your cross sheet reference {Areas Improved} to make sure it is setup correctly

bryanl

@Leibel S That is exactly what I needed, thank you!!

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.