Ben,

Hope everything is clear now ...
Shail's explanation is excellent

Now you are left with following
in column D, type in

=SUMIF($A$2:$A$3000,C2,$B$2:$B$3000)

and copy all the way down ...

Cheers
Carim