View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FPJ FPJ is offline
external usenet poster
 
Posts: 19
Default sumproduct function

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