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

Have you tried sorting them based on t6? This way all the 01 would be next to each other, then you can easily sum the values.

You should use excel. Put the t6, code and VALUE in different columns. You can then sort by a specific (like 01 in t6) then add the total by using =SUM(CELLNUMBER:CELLNUMBER)

Example =SUM(A1:A4)

Have you tried the "subtotal" feature under the "DATA" menu?

If you use it and then select the 2 tab in the upper left corner, it will show just the totals of each "t6"