RE: Combining same data in multiple rows

Create a unique list of products in, say, column C:
Data>Advanced filter>Check Copy to another place checkbox, List range:
$A:$A, Filter range: $A:$A, Copy to: $D$1

Enter this formula in E2 and fill it down:

=SUMIF(A:A,C2,B:B)

Regards,
Stefi

„Susienak” ezt írta:

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!!!


.