| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine rows and sum data with the same id
Hi,
Here is an example of the data I have. Account ID Amount 101567 $505.00 101567 $875.00 101567 $2,450.50 253570 $1,178.90 253570 $875.00 346677 $1,928.33 I have thousands of accounts with multiple amounts having the same ID and I need to add these amounts and combine them so that there is only one row per account ID. Please help... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine multiple rows with like data in Excel? | Excel Discussion (Misc queries) | |||
| Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
| How do I combine data from separate Excel rows | New Users to Excel | |||
| Combine the data in 2 columns of 20 rows into one column of 40 row | Excel Discussion (Misc queries) | |||
| Combine data rows in Pie Chart | Charts and Charting in Excel | |||
Threaded Mode
