Counting in a cell with multiple options
I am trying to create a formula that will count each time a department has been selected in a sheet. This column has the option to add multiple departments to one row. How do I make a formula that will count each one?
For example in the screenshot below, I am trying to find out how many times each option was selected.
Can someone help me with a formula for this?
Help Article Resources
Check out the Formula Handbook template!