Counting Multi-Select Column value, based on another Column value

Given the following Grid - I am trying to count all instances of 'Apple' in a Multi-Select Column ('Fruit'), but only when another column ('Market') has a value of 'Market A'

So in the above example, the answer would be 1, as whilst 'Market A' appears twice in the 'Market' column, 'Apple' only appears in the first instance ['Market A'].

Thank you in advance for any help!

Will

Find more posts tagged with

Formulas

Accepted answers

All comments

Leibel S

@wtcf

See below:

=COUNTIFS(Market:Market, @cell = "Market A", Fruit:Fruit, HAS(@cell, "Apples"))

Kate Cooper

@Leibel Shuchat

Would you know how to do this with a column of search values?

Leibel S

@Kate Cooper What you mean?

Kate Cooper

@Leibel Shuchat

Like if you were to want to search not just using the string "Apple" but instead using multiple values from a column. Say there is a column with the types of fruit, would you be able to use that instead of the search term "Apple"

I have tried something like

=COUNTIFS(Market:Market, @cell = "Market A", Fruit:Fruit, HAS(@cell, [Fruit Type]@row))

But this does not work properly.

Leibel S

Sounds like you want to check a multi column against a multi column, not really any way to do that

Kate Cooper

@Leibel Shuchat

Thanks for your insight. I appreciate your response.

Paul Newcome

I got it to work on a multi-select column, but I may be misunderstanding your ask. Are you able to post some screenshots of sample data for reference?

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.