Use the formula I posted and change it to this

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



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


"Jennie" wrote in message ...
sorry to bother you again, I'm still getting a #ref error with the new
formula. is there another one I can use?

"Ron de Bruin" wrote:

=sumproduct((A1:A10(B1:B10)=c1)*c1)

use this

=sumproduct((A1:A10(B1:B10)=C1)*1)
don't use *c1

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


"Jennie" wrote in message ...
I'm looking for a generic formula that will work for any month, not just
January. In place of month I tried to type in a range of cells (say A1:a10)
and instead of "1" I tried to type in the cell where I will enter the month
I'm interested in (say C1), but this gives me a #ref error.
So I tried: =sumproduct((A1:A10(B1:B10)=c1)*c1)
How can I make a generic formula that will work for any month?

"Ron de Bruin" wrote:

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.