Need Help Formulating a spreadsheet

[Greg]

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

 

[JMB]

If "lemons" is in C1, try

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

 

[Martin Fishlock]

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

The other was is to sort and use subtotals.

 

[Martin Fishlock]

For the pivot table:

In the pivot table put product in the row area on the left and count in the
data area (on the right at the bottom) and make sure it says sum of count.

Then it should work.