Count number of occurrences

Question

Original Table of ResultsNameGroupStatusJoemarketing, all usersPassedMarydigital1, all usersIn ProgressJohndigital2, all usersNot StartedBobmarketing, all usersPassedDillondigital2,all usersPassed&nbsp;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&nbsp;Group NamePassedIn ProgressNot Startedmarketing200digital1010digital2101&nbsp;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?&nbsp;

hansvogelaar · Accepted Answer

Gerry_Morley&nbsp;
You can use COUNTIFS with a wildcard for the group:

See the attached sample workbook.

Forum Discussion

Count number of occurrences

2 Replies

Resources

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

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