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

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!

Find more posts tagged with

Accepted answers

Sharon W.

Figured it out!

Sharon W.

@Jeff Reisman Sure!

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

All comments

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))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.