Help with multi selections and counting specific items/text
Hi team - I have a column that is multi select for with following:
- Microsoft Exchange Server 2013
- Microsoft Exchange Server 2016
- Microsoft Exchange Server 2019
- N/A
Question - how do I do a summary formula to count for something specific like Microsoft Exchange Server 2013 when other selections are made as well?
If I do a straight "countif" I've only been able to return a count of those column rows that ONLY have Microsoft Exchange Server 2013 but need to also count column rows that might have 2013 as well as 2016 and 2019.
Any ideas?
Best Answer
-
Hi @jmoser,
I believe the answer by Paul Newcome might help you for specific counting.
If not please let me know,
Sam
Answers
-
Hi @jmoser,
I believe the answer by Paul Newcome might help you for specific counting.
If not please let me know,
Sam
-
Yep - that absolutely answered it, @Sam M. !
Ironically, I tried COUNTIFS and CONTAINS but obviously had my brackets and quotes in the wrong place.
Thanks for the assist!
-
You're welcome!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!