How to use a COUNTIF formula to determine how many times a word appears in a multi-select column?

Sharon W.

Hi, I have columns that allow users to "select all that apply" however, I want to be able to summarize/count the number of times each value appears.

For Example:

Column: Fruit

Cell 1: Apples, Pears Bananas

Cell 2: Apples, Pears, Oranges

Cell 3: Apples, Oranges, Bananas

Summary:

Apples: 3

Pears: 2

Bananas: 2

Oranges: 2

The formula I am currently using, will only allow count the "apple" value if it is the only value in a cell.

Thank you!

Sharon W.

Figured it out!

Sharon W.

@Jeff Reisman Sure!

=COUNTIFS([Fruit]:[Fruit], CONTAINS("Apples", @cell))

Sharon W.

Figured it out!

Jeff Reisman

@Sharon W.

If you can, please post your solution here so that others searching the community for the same issue may find it. Thanks!

Sharon W.

@Jeff Reisman Sure!

=COUNTIFS([Fruit]:[Fruit], CONTAINS("Apples", @cell))