How to count rows with more than one selection in a drop down menu?

PMVie

Hello you pros, I looked for an answer but was unsuccessful.

I have a column with a multi-select dropdown menu. The selections are for product categories in the cannabis industry (flower, edibles, concentrates, vapes etc)

I have found a working formula to count how many projects have a single category (thank you community!).

How do I count the projects that involve more than one category? I just want to report how many projects are multi-category no matter if they have 2,3 or 4 categories affected by the project scope.

Thank you!

Paul Newcome

You would want something along the lines of...

=COUNTIFS({Range}, COUNTM(@cell) > 1)

Paul Newcome

You would want something along the lines of...

=COUNTIFS({Range}, COUNTM(@cell) > 1)

PMVie

That's it! Thanks Paul - I am nerding out and having so much fun with all this data. Woot woot!

Paul Newcome

Happy to help. 👍️