complex problems count based on many levels of criteria

Hello!

I need some help with a complex formula. I have thousands of rows of data that is continuously increasing.

There are two ways the data can be looked at (across Type only and across Type and Size combo).

I need to find the number of times for each a month/year and CP type in which there was a problem. Specifically, if a Type fails (once or more) on any of the series (1-6), then it needs to be counted ONLY ONCE.

In addition, for both these ways, the data needs to be parsed by month/year and CP type.

For Type Only
If everything is ok for that Type, then it is a "0" for that Type
If one or more problems are identified within a Type, then it needs to be counted only ONCE (no matter how many problems were identified)

For Type and Size combination
If everything is ok for that type and size combo, then it is counted as a "0"
If one or more problems are identified within a Type and Size combo, then it needs to be counted only ONCE (no matter how many problems were identified)

I am fine with adding columns to help with the formulas.

I included mock data along with what that data should look like. Its pretty complicated, so I colored the data to help identify the Type (color) and Type and Size (light/dark).