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

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.

Find more posts tagged with

Accepted answers

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! 😊

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.