Count the number of rows where a column (multi select dropdown) has more than one value

latheobald89201

Hello

I would like to count the number of rows where Attendee Role which is a multi select dropdown has more than one item selected regardless of the item.

Countif({Attendee Role},"*,*") Returns 0

CountM({Attendee Role},"*,*") returns 187 which is the number of rows with 2 selections x 2 counting each selection once (I only have a total of 177 rows so I know this is wrong). I just want to count the rows once.

Nick Korna

Hi @latheobald89201,

This should work:

=COUNTIF({Attendee Role}, COUNTM(@cell) >= 2)

Hope this helps, but if you have any problems then post what they are! 😊

Nick Korna

Hi @latheobald89201,

This should work:

=COUNTIF({Attendee Role}, COUNTM(@cell) >= 2)

Hope this helps, but if you have any problems then post what they are! 😊

meb_0101

Thank you so much @Nick Korna! Your answer helped me solve a related formula issue I was struggling to find an answer for.

Nick Korna

No problem @meb_0101; it's always good when an answer helps out someone else as well as the person asking the original question! 😃

latheobald89201

Thank you