COUNTIF with multiple select dropdown column

Del Horne

Hi,

This has me going mad! 🤬🤣

I have a sheet reference "Business Area" which has a column type of dropdown multi-select. I'm then using a COUNTIF on specific values to compile a metric sheet.

This is counting fine where the dropdown has "C" and "E" selected:

=COUNTIF({Business Area}, @cell = "C" + CHAR(10) + "E")

However, when "iP" and "S" are selected the COUNTIF returns 0 which I know is not the case:

=COUNTIF({Business Area}, @cell = "iP" + CHAR(10) + "S")

If I count the "iP" and "S" separately all is fine, it's only when I try to count as combined selected values...

Any thoughts please?

Thanks!

Del

Paul Newcome

Try something more like this...

=COUNTIFS({Business Area}, AND(HAS(@cell, "iP"), HAS(@cell, "S")))

Paul Newcome

Try something more like this...

=COUNTIFS({Business Area}, AND(HAS(@cell, "iP"), HAS(@cell, "S")))

Del Horne

Thank you @Paul Newcome - that works perfectly!! 👍️👍️👍️

Paul Newcome

Happy to help. 👍️