Try:
Code:
=SUMIFS(CODES!D$2:D$34,CODES!$C$2:$C$34,$B3)
copied down and across.
or if you need to also match the column headers because they may not be in consistent order, then
Code:
=SUMIFS(INDEX(CODES!$D$2:$F$34,,MATCH(C$2,CODES!$D$1:$F$1,0)),CODES!$C$2:$C$34,$B3)