Formula to Use in Multi Select Column

Kate Gallo

Hello!

I have a column that is set up as a multi select with four options in the drop down, and I would like tally of the total number of times each option was selected.

So for example, if my four options were Apples, Bananas, Peaches, Grapes, and people are able to select any or all of those options in a single cell, I would like a total of the number of times Apple was selected, a total for the number of times Banana was selected, etc.

I haven't had any luck with the formulas I have tried - does anyone have any suggestions?

Thanks so much!!

Sameer Karkhanis

Try this for each,

=COUNTIF([Column Name]:[Column Name], HAS(@cell, "Apples"))