View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Need Help Formulating a spreadsheet

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