Count Multi-Select Options

Hi Community,

I have a multi-select column where I need to count the number of values selected (just the total, not individually). Is there a formula to help with this?

Below is a screenshot of my cell (Rollover) and the outcome I'm looking for (Months Rollover).

Thank you as always!
~Jaime 😀

Find more posts tagged with

Sheets

Formulas

Accepted answers

Protonsponge

Hello @Jaime Ciabattoni

Would this work for you - =COUNTM([Multi Select Drop Down]@row)

The below is from LINK

COUNTM Function:-

Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.

All comments

Protonsponge

Hello @Jaime Ciabattoni

Would this work for you - =COUNTM([Multi Select Drop Down]@row)

The below is from LINK

COUNTM Function:-

Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.

Jaime Elizabeth

Yes! Thank you @Protonsponge!

Protonsponge

Great, pleased you got something that worked for you.

I'm grateful for the opportunity to help you out,

Protonsponge

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.