Try:

=SUMIF($B$2:$B$8,B2,$D$2:$D$8)


adjust ranges to suit,

or

=SUMIF($B:$B,B2,$D:$D)