Hi Jennie

This will count the dates that are in Jan in B1:B10

=SUMPRODUCT((MONTH(B1:B10)=1)*1)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jennie" wrote in message ...
hi all,
I'd like to make a summary sheet that will count the total # of product
within a certain month so if I type in the month # in one cell the # of total
products will show up. for example

month # product
1 a
1 b
2 a

so if I type in 1 for month, 2 will show up for products.
thanks in advance.