Product by Month formula
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
|