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!
Help Article Resources
Check out the Formula Handbook template!