Hi

in D19 and copied down & across,

=SUMPRODUCT(SUMIF($C$5:$C$15,INDEX($J$20:$M$27,,MA TCH($C19,$J$19:$M$19,0)),D$5:D$15))

Note: Some of the descriptions have trailing spaces. So please remove it to get the correct results.