Count items in multi dropdown list

Magda

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!

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

Magda

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

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

Magda

Hi @Kelly Moore

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

Magda