Count number of occurrences

[Gerry_Morley]

Original Table of Results

Name	Group	Status
Joe	marketing, all users	Passed
Mary	digital1, all users	In Progress
John	digital2, all users	Not Started
Bob	marketing, all users	Passed
Dillon	digital2,all users	Passed

Hi all, I have the above table and then I have another table with a column with a set number of known groups (See first column in table below) that I want to look for in above table and then count up the corresponding results and put count results under relevant heading.

Example of output 

Group Name	Passed	In Progress	Not Started
marketing	2	0	0
digital1	0	1	0
digital2	1	0	1

I assume I need to use CountIF and VLookup perhaps but not sure how to do it especially since the group field in the first table can have multiple groups in it so it will never be exact match - instead one has to look for the reference group cell to see if the text of it exists in the column of the original table. Can anyone help? 

[#2 · Accepted solution]

@Gerry_Morley 

You can use COUNTIFS with a wildcard for the group:

See the attached sample workbook.

[#3]

Thank you very much. This is super helpful. Really appreciate it.