Try a pivot table it will summarize the data for you.

The other was is to sort and use subtotals.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"JMB" wrote:

If "lemons" is in C1, try

=Sumif(A1:A4, C1, B1:B4)


"Greg" wrote:

Hi
Example of spreadsheet

A B
Product Count
1 lemons 9
2 apples 5
3 lemons 12
4 pears 2

I have a spreadsheet with a large amount of products with counts I need to
sort the product that are the same and add up the counts if anyone can give
me a formula it would be great