Counting the amount of days

[blackgolf]

Hi
I would appreciate help with the following as none of my sumproduct, countif etc is working;

In Column A I have a list of days as below;
2012/06/02
2012/06/03
2012/06/04
2012/06/04
2012/06/04
2012/06/05
2012/07/02
2012/07/03
etc.
In the same row of each I have Column L with a 6 and Column M with 2012 (the month and year)
So I want to count the amount of days in Column A when there is a 6 in Column L and 2012 in Column M.
It MUST NOT count the duplicate day, like 2012/06/04 must only be counted once. It must also not count 2012/07/02 and 2012/07/03.

Thanks in anticipation.
Regards
Chris

 

[martindwilson]

=MAX(IF((MONTH(A1:A8)=6)*(YEAR(A1:A8)=2012),A1:A8))-MIN(IF((MONTH(A1:A8)=6)*(YEAR(A1:A8)=2012),A1:A8))+1 array entered maybe