Hi,

You need to coerce the OFFSET to numerical values with N() first:

=SUMPRODUCT(N(OFFSET($M$5,MATCH($H$7:$H$12,$L$6:$L$8,0),0,1,1)),$I$7:$I$12)

Regards