Help with multi selections and counting specific items/text

jmo ✭✭✭✭✭✭
edited 03/22/21 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!