Count with criterion.criteria within multi-select cell
I have multi-select cells in a sheet. I can use countm to count all selected items in a specific cell. However I need to count specific selections based on criteria. For example: A dropdown contains:
L1-ABC, L1-LMN, L1-XYZ,L2-ABC,L2-LMN,L2-XYZ, L3-ABC,L3-LMN,L3-XYZ
One cell has: L1-ABC,L2-XYZ,L2-ABC,L3-XYZ
I want to search how many times a selection started with L2 was made? So the formula should return 2 for the above cell.
Help Article Resources
Check out the Formula Handbook template!