A1.....................B2

apples.................3

pears..................2

apples.................5

Grapes.................2

apples..................1

and so on for 125 rows with diff products.

I am using vlookup to count the total number of apple sales but it only
counts one row, can I make this work, or do I need another formula.

I need produce a sales overvew with no of sales per product.

Thanks for any help in advance

mark

Ps I had to use ................. to get it to space properly


--
Markyboy
------------------------------------------------------------------------
Markyboy's Profile: http://www.excelforum.com/member.php...o&userid=29493
View this thread: http://www.excelforum.com/showthread...hreadid=513167