Perfect. But one more thing. What if I want by month and year? That is, I
need to separate January 2007 from January 2008. thanks.
--
Brian


"Gaurav" wrote:


For Counting Wagons in January
=SUMPRODUCT((MONTH($A$2:$A$20)=1)*($B$2:$B$20="Wag on"))

For Feb, change 1 to 2. 3 for march and so on. Instead of typing wagon, try
using a cell reference. Suppose you have Wagon in D2 then use the following.
=SUMPRODUCT((MONTH($A$2:$A$20)=1)*($B$2:$B$20=D2))


"Brian" wrote in message
...
I need a formula which will count the number of sales of each product by
month where there is only one cell entry for each sale. Column A is the
date
the sale is made; Column B is the type of product (eg. car, wagon, RV).
I
want a formula that can tell me how many sales of each product occured in
January, February, etc.
Again, each sale is entered on a different row, so I think the formula
would
somehow just count the number of cells in the date range that also related
to
each product. Can someone help?
thanks.
--
Brian