Multi-Select Columns and Counting Occurrences

Amy Evans

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

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