Adding sales in same column?

M

Markyboy

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
 
D

Dav

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

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

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

regards

Da
 
Top