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