sum of total identical DC numbers

Date DC# PARTY NAME QTY SIZE TYP @ ITEM TOT DC TOTAL
01-07-15 10894 PAPER TRADERS 7 28 Ff 15.25 2,989
01-07-15 10894 PAPER TRADERS 9 26 Nf 21.00 4,914
01-07-15 10894 PAPER TRADERS 5 26 Ff 15.25 1,983 129,818
02-07-15 10942 PAPER TRADERS 12 34 Nsf 24.75 10,098
02-07-15 10942 PAPER TRADERS 3 29 Ff 15.25 1,327
02-07-15 10942 PAPER TRADERS 7 26 D2f 20.00 3,640
02-07-15 10942 PAPER TRADERS 2 26 Ff 15.25 793
02-07-15 10942 PAPER TRADERS 7 32 Ff 15.25 3,416
02-07-15 10942 PAPER TRADERS 4 28 Ff 15.25 1,708 40,017
02-07-15 14789 SAM 8 28 D2f 20.75 4,648
02-07-15 14789 SAM 4 28 Ff 14.75 1,652 6,300
02-07-15 14789 SAM 13 32 d2f 20.75 8,632 14,932
03-07-15 10988 PAPER TRADERS 6 35 D2f 20.00 4,200 4,200

...with a bit of an explanation of what you want!!

In J3

=IF(COUNTIF($B$3:$B3,B3)=COUNTIF($B$3:$B$22,B3),SUMIF($B$3:$B$22,B3,$I$3:$I$22),"")

Copy down

Go with Ace_XL's.. but just for completeness, this is what I came up with (far inferior, I'm afraid!!)