Try this version for row 8

=SUMPRODUCT(OFFSET(8:8;0;MATCH(9.99E+307;8:8)-4;1;4);{1\2\3\4})/10