See if this could work:
=SUMPRODUCT(--(B3:N3<0),INDEX(data1,B3:N3+1,MATCH($B$2,data2,0) ))

Ola Sandstrom