# Count items in multi dropdown list

✭✭✭
edited 03/17/23

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!

• ✭✭✭✭✭✭

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

• ✭✭✭

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

• ✭✭✭✭✭✭

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

• ✭✭✭

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

Magda

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!