counting unique values across several criteria and date (month/year)

[joannelittell]

Greetings!

I need to capture whether or not a group during a specific month/year and CP has had any problems. If the group has had one or more problems, it is counted.

I also need it so if there are no groups that occur in a month/year, the result is a blank "".

I have included a spreadsheet with mock data (on the left) and what the results should be in a table (on the right). I have also included notes explaining the different scenarios.


Thanks for taking the time to assist me!!
Joanne