Brian,

Select your data table, then choose Data / Pivot Table, and click Finish.

Then drag the "date" button to the Row Field, and the "type" button to the column field, and "type"
button again to the Data Field.

Right-click on the date and choose "Group and show detail" then "Group", and select "Months" in the
"By" selection field, and you're done.

HTH,
Bernie
MS Excel MVP


"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