Hello,

consider the following screenshot. The formula in cell K2 is

=SUMPRODUCT($C$3:$H$8*($A$3:$A$8=$J2)*($C$1:$H$1=K$1))

copied across and down.

2015-05-21_21-21-06.png

cheers, teylyn