Formula for Counting Cell with Multiple Selections

I want to count only the cells with "Order Coordinator" and "Import/Export" and no other Functional Area entries. The calculation would not count the entry with "Customer Service".

Answer: Should equate to 4.

Thank you in advance for your support.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!