View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susienak Susienak is offline
external usenet poster
 
Posts: 13
Default Combining same data in multiple rows

I have two columns of information: Column A has a number that represents a
product and Column B shows how many times that product was sold. I combined
the data from multiple worksheets so the product numbers repeat:

Prod# Product sales
610 3
611 1
612 5
612 1
612 3
613 5
613 1
613 2
614 1
614 4
614 1
622 1
622 3
622 2
623 2
623 12
623 2
624 2

How do I combine the product numbers in Column A to give me the total
products sold in Column B. Ex: Product#623 was sold twice today from one
website, 12 times from another website, and twice from yet another website
yielding 16 sales for product #623.

My list contains 30,000 numbers and Im looking for it not to sum up the
product numbers, just yield one sum for each product number. Help please!!!