=SUMPRODUCT(--(YEAR(A1:A20)=2007),--(MONTH(A1:A20)=2),--(B1:B20="washers"))


--
Regards,

Peo Sjoblom



"FPJ" wrote in message
...
On the table below, I want to count how many times did we purchase washers
in
February of 2007. How can I write this in SUMPRODUCT FUNCTION? Please
help.
Thanks.
A B
1 1/04/05 nails
2 1/23/05 screws
3 4/05/05 screws
4 2/22/06 washers
5 6/25/06 nails
6 8/03/06 washers
7 2/15/07 washers
8 2/21/07 washers
9 2/26/07 nails
10 4/21/07 washers
11 5/04/07 washers

fpj