Formula for Counting Cell with Multiple Selections

Anthoni

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.

Samuel Mueller

Following up with your post here: Assistance Needed- Count of Cell with Multiple Functions Selected — Smartsheet Community

you can achieve this with this formula: =COUNTIFS([functional area]:[functional area], "Order Coordinator" + CHAR(10) + "Import/Export")