軟體:EXCEL
版本:2010
手上有一筆數據要分析，預想的效果如下
第一列：=COUNTIF($B$2:$B$77613,">=2.495")-COUNTIF($B$2:$B$77613,">=2.505")
第二列：=COUNTIF($B$2:$B$77613,">=2.505")-COUNTIF($B$2:$B$77613,">=2.515")
第三列：=COUNTIF($B$2:$B$77613,">=2.515")-COUNTIF($B$2:$B$77613,">=2.525")
第四列：=COUNTIF($B$2:$B$77613,">=2.525")-COUNTIF($B$2:$B$77613,">=2.535")
.....
但是直接做十字下拉沒辦法達到想要的效果，請問要用什麼函式達到呢?