Formula which references dropdown menu with multiple values per cell

maevewilliams

Hello!

I am using a COUNTIFS formula which references a dropdown menu and when I adjusted the dropdown menu to allow for multiple values per cell the formula did not capture the adjusted data. Do I need to use a different formula?

Paul Newcome

You would need to incorporate the HAS function.

=COUNTIFS([Dropdown Column]:[Dropdown Column], @cell = "A")

would change to

=COUNTIFS([Dropdown Column]:[Dropdown Column], HAS(@cell, "A"))