Count items by month/year

  • Thread starter Thread starter Kym
  • Start date Start date
K

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
 
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
 
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




.
Click to expand...
 
Back
Top