连续3年业绩大于100的平均 (11176)

M3{=IF(SUM((B3:I3>100)*(C3:J3>100)*(D3:K3>100))=1,AVERAGE(OFFSET(A3,,MATCH(1,(B3:I3>100)*(C3:J3>100)*(D3:K3>100),),,3)),"")

另解{=IFERROR(AVERAGE(IF(FREQUENCY(IF(B3:K3>100,COLUMN(B:K)),IF(B3:K3<101,COLUMN(B:K),))=3,N(OFFSET(A3,,ROW($1:$11)-{1,2,3})))),"")