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

=SUMIF($A$2:$A$126,"Apples",$B$2:$B$126)

Where a2:a126 is your range of categories, b2:b126 is your range of
sales

apples can be replace by a cell containing apples and the formula can
be copied down if the other categories are below

regards

Dav


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

You are a star

Cheers


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