Avatar of Michael Vasilevsky
Michael Vasilevsky
Flag for United States of America asked on

Return Count of Instances of Strings in a Column Matching List of Strings in Another Column

I'm looking for a formula that can be applied to a column that will return the count of instances of strings defined in another column. Refer to the attached example:

Example.xlsx

Ex. 1 should return 6 because there is 2 instances of item1, 2 instances of item2, and 2 instances of item9. Item3 and item4 are not included in the count because they are not in the Criteria column.

Any questions let me know!
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Michael Vasilevsky

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Norie

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Michael Vasilevsky

ASKER
That'll do! Thanks
Michael Vasilevsky

ASKER
Thank you!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes