软件: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")
.....
但是直接做十字下拉没办法达到想要的效果，请问要用什么函式达到呢?