If I've understood

B7:
=SUMIF(B$2:B$6,RIGHT($A7),$D$2:$D$6)
applied to matrix B7:C9