Quite a tricky SUM question

Originally Posted by ChemistB

In C5 copied down;
=INDEX($D$2:$H$2, MATCH("?"&MID(B4,2,1)&"?"&MID(B4,4,1),$D$1:$H$1,0))
Does that work for you?

that's perfect thanks very much Chemist