Multi-Select Columns and Counting Occurrences

UPDATE:

Solved it....

=COUNTIFS({Category Lifecycle}, CONTAINS(Category@row, @cell))

Please ignore below.

Hello,

I have a column with multi-selects. I want to be able to count the occurrences of each selection.

My formula only counts the selections when they are by themselves. When a selection is part of a multi-select, the formula doesn't acknowledge it.

=COUNTIFS(Options:Options, [Total Selections]@row)

The correct answer for total count of "Option 1" should be "3." There are 3 occurrences of Option 1.

Thanks,

Amy

Find more posts tagged with

Accepted answers

All comments

Eric Law

@Amy Evans Nice! I would also recommend that you place those in the sheet summary instead of in the sheet itself... unless that's just a test sheet lol

Amy Evans

Yes, I have a separate sheet summarizing the stats.

Thank you,

Amy

RhondaRhocks

Thank you so much Amy!!!! Many life minutes to find this solution. Thank you putting update on top. Worked like a charm.

Rhonda

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.