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
Answers
-
@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
-
Yes, I have a separate sheet summarizing the stats.
Thank you,
Amy
-
Thank you so much Amy!!!! Many life minutes to find this solution. Thank you putting update on top. Worked like a charm.
Rhonda
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!