區間 負數出現次數 9 (10125)


E2=INDEX(FREQUENCY(B$2:B$11,{-8,-4}),4-ROW(A1))


(數據需全 <= 0) =INDEX(FREQUENCY(ABS(B$2:B$11),{3,7}),ROW(A1))


留言