combine rows and sum data with the same id

T

tenny

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...
 
M

Max

One good, quick way - Use a pivot. It'll deliver exactly what you seek, in a
matter of seconds, and despite the voluminous data

Create a pivot (click Data>PivotTable), then in step 3 of the wizard, click
Layout, drag n drop "Account ID" into ROW area, "Amount" into DATA area
(it'll show as Sum of Amount). Click OK > Finish. That's it. Hop over to the
pivot sheet for the amazing results delivered: a listing of all the unique
Account IDs in a column with their corresponding sums next to it

Wave your success here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
M

M Thompson

Hi Tenny

I'd use Data Consolidation. If your data is arranged as you showed, then
just click in the cell where you want your data to start-I would place it on
another worksheet. Go to Data>Consolidate and choose Sum in the "Function:"
box. Then click the minimize button in the "Reference:" area. Highlite the
account numbers and data in your spreadsheet, then click back into the
Consolidate box. Click the Add button. In the "Use labels in" box, click
Left column, then click OK. If done correctly, you should have 1 row for
each unique account # and the corresponding summed amounts on the new
worksheet.

Please let me know if it works...
 
Top