i have a list of about 5000 items in excel, they have two digit codes

t6code VALUE
0019400000212,857
00194000001,379,133
01141200002,261,203
0112110000598,921
02122100002,814,042
0213100000310,428

i want to add all t6 that are the same (all 01 etc) DSUM will not work i have 5000 items with a lot of different t6. HELP!!!!!!
the t6, code and value are in different columns and there are about 80 different t6 codes

A Pivot Table will do this easily for you.

1) select all your data; just be sure that each column in your selected data has a heading at the top.

2) Data - PivotTable and PivotChart Report, this will bring up the pivot table wizard
- step 1: say OK
- step 2: make sure all your data is selected
- step 3: pick whether you want it in a new sheet
This will create the empty table structure.

3) You should have a list of fields on the right, showing t6, code, and VALUE
- drag the t6 field to where it says "Drop Row fields here" on the left
- drag the VALUE field to where it says "Drop Data Items here"
- right click where you dropped the VALUE field, pick Field Settings, and make sure Summarize by on the left says "Sum"

You will end up with a table that has a row for each t6, and the total of all the VALUEs for that t6.

If you need more info, pls. add detail or e-mail.
Good luck!
.