Count items by month/year

[Kym]

Could someone please help me out with this problem, I
would like to count items say in column "A" by the month
and year stated in column "B"

For example column "A" has a,c,a,b,b,a,c etc. Column "B
has date codes 12/21/03, 10/02/03, 10/02/02 etc.

I need to know for example how many times "a" appears in
the month of January in the year 2003.

Thanks

 

[JMay]

Your letters a, c,b,c,b,a, in A1:A20; Your Dates in B1:B20
In D1 >>> Enter Desired letter c sample
In D2 >>> Enter Desired Month 2 a number 2 for February
In D3 >>> Enter Desired Year 2003 a number for year

In D5 enter
=SUMPRODUCT(((A1:A20)=D1)*(MONTH(B1:B20)=D2)*(YEAR(B1:B20)=D3))

Should product desired result!!
HTH

 

[Kym]

Thank you

This works great

Kym

-----Original Message-----
Your letters a, c,b,c,b,a, in A1:A20; Your Dates in B1:B20
In D1 >>> Enter Desired letter c sample
In D2 >>> Enter Desired Month 2 a number 2 for February
In D3 >>> Enter Desired Year 2003 a number for year

In D5 enter
=SUMPRODUCT(((A1:A20)=D1)*(MONTH(B1:B20)=D2)*(YEAR (B1:B20)=D3))

Should product desired result!!
HTH




.