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

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


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!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!