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.
Help Article Resources
Check out the Formula Handbook template!