Help with multi selections and counting specific items/text

jmo

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?

Sam M.

Hi @jmoser,

https://community.smartsheet.com/discussion/66868/using-countm-to-return-count-on-specific-items

I believe the answer by Paul Newcome might help you for specific counting.

If not please let me know,

Sam

Sam M.

Hi @jmoser,

https://community.smartsheet.com/discussion/66868/using-countm-to-return-count-on-specific-items

I believe the answer by Paul Newcome might help you for specific counting.

If not please let me know,

Sam

jmo

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!

Sam M.

You're welcome!