總得分 刪最高分與最低分 (11949)

I2:I9=SUMPRODUCT(SMALL(B2:H2,ROW($2:$6)))

B12=COUNTIF(B2:H9,">8.9")

B13=COUNTIF(B2:H9,"<8")



留言