Count Multi-Select with conditions


I have a ongoing sheet with Clients (Single Select Dropdown) and Tests (Multi-Select Dropdown). I'd like to know the ongoing total of Tests selected per Client. I can't seem to figure out if this is a combination of Countifs and CountM or if I should use Collect, Has, Contains. I know this is simple I just can't put it together.

See pictures below:

I'm making a metrics sheet where I'd like to show the data as follows:

Any help would be greatly appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!