| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining data from different rows into 1 column | Excel Discussion (Misc queries) | |||
| Combining rows with similar data | Excel Discussion (Misc queries) | |||
| Combining rows of like data? | Excel Worksheet Functions | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| combining multiple rows into 1 record | Excel Worksheet Functions | |||
Threaded Mode
