software

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: www.excelforum.com/member.php...oamp;userid=29493
View this thread: www.excelforum.com/showthread...hreadid=513167
=SUMIF($A$2:$A$126,quot;Applesquot;,$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: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=513167
You are a star

Cheers--
Markyboy
------------------------------------------------------------------------
Markyboy's Profile: www.excelforum.com/member.php...oamp;userid=29493
View this thread: www.excelforum.com/showthread...hreadid=513167