合乎多條件數 (12965)

I2:J4=SUMPRODUCT(($A$2:$A$11=$H2)*($B$1:$E$1=I$1)*($B$2:$E$11<0.5))

另解=COUNTIFS($A$2:$A$11,$H2,OFFSET($A$2,,MATCH(I$1,$1:$1,)-1,10),"<0.5")