unique docs not compliant per month

[joannelittell]

My data has numerous documents that span many years. Each of these documents have many elements that can be either "compliant" or a reason why that element is not compliant.

I need a breakdown by month and year the number of documents where at least one element was not compliant.

NOTES:
- I can not download anything (as this is a work computer).
- I will be handing this off to others that just want to open it and see the results.

Examples:
- A document had all its elements that were not compliant, that month/year would increase by 1.
- A document had all its elements that were "compliant" except one, that month/year would increase by 1.
- A document had all its elements that were "compliant", that month/year would not increase.

Please note that the elements that are not compliant- have various explanations in the data, so i can't just look for the words "not compliant".

For the data below:
Feb 2013 = 3
Mar 2013 = 0
Apr 2013 = 1
.
.
.
Feb 2014 = 1

date...................document.......compliant?
02/05/2013.........bbb...............jump
02/05/2013.........bbb...............walk
02/05/2013.........bbb...............compliant
02/08/2013.........ggg...............compliant
02/25/2013.........ddd...............compliant
02/25/2013.........hhh...............sit
02/25/2013.........hhh...............jump
02/25/2013.........aaa...............compliant
02/25/2013.........aaa...............smile
03/25/2013.........eee...............compliant
03/25/2013.........eee...............compliant
04/25/2013.........fff.................walk
04/25/2013.........fff.................compliant
02/12/2014.........ccc................sit

[Fotis1991]

=SUMPRODUCT((YEAR(A1:A100)=2013)*(MONTH(A1:A100)=2)*(C1:C100="compliant")) ???????

[Tony Valko]

Try this...

With your data in the range A2:C15...

Enter the 1st of the month dates in E2:E4...

E2 = 2/1/2013
E3 = 3/1/2013
E4 = 4/1/2013

Then, this array formula** entered in F2 and copied down:

=SUM(IF(FREQUENCY(IF(A$2:A$15-DAY(A$2:A$15)+1=E2,IF(C$2:C$15<>"compliant",MATCH(B$2:B$15,B$2:B$15,0))),ROW(B$2:B$15)-ROW(B$2)+1),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[Pepe Le Mokko]

The attached perhaps ? (PT as already suggested)