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
Answers
-
-
Would you know how to do this with a column of search values?
-
@Kate Cooper What you mean?
-
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.
-
Sounds like you want to check a multi column against a multi column, not really any way to do that
-
Thanks for your insight. I appreciate your response.
-
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?
Help Article Resources
Categories
Check out the Formula Handbook template!