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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!