Count items in multi dropdown list

Hi everyone,

I am trying to count items individually from a multi-select column in a sheet called "Other Sheet" by adding the following formula to a separate sheet:

=COUNTIFS({Other Sheet}, CONTAINS("Value 1", {Other Sheet}))

It's not working, and I am getting "0" for all the items (which is not true).

Any ideas what's happening?

Thank you!

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Magda

The range you need within the CONTAINS() function is the @cell. Since you have already given the range in the COUNTIFS() function, you now need to tell the CONTAINS() function (or the HAS() function if CONTAINS doesn't give you the expected result) to check each cell in that that COUNTIFS range.

=COUNTIFS({Other Sheet}, CONTAINS("Value 1", @cell))

If your value 1 is a number, do not enclose it in quotes. =COUNTIFS({Other Sheet}, CONTAINS(1234, @cell))

Does this work for you?

Kelly

All comments

Magda

Sorry, forgot to mention that the column in "Other Sheet" is a multi-select column

Kelly Moore

Hey @Magda

=COUNTIFS({Other Sheet}, CONTAINS("Value 1", @cell))

If your value 1 is a number, do not enclose it in quotes. =COUNTIFS({Other Sheet}, CONTAINS(1234, @cell))

Does this work for you?

Kelly

Magda

Hi @Kelly Moore

Thank you so much for taking the time to reply! It worked! 😀

Magda

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.