excel里如何计数某个区间内的个数
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/07/14 07:14:07
excel里如何计数某个区间内的个数
如图,我A列是一列吨数,然后我想统计比如2000~3000有多少个,3000~4000有多少个等,有没有简洁的方法,因为我数据比较多,谢谢
![excel里如何计数某个区间内的个数](/uploads/image/z/899352-0-2.jpg?t=excel%E9%87%8C%E5%A6%82%E4%BD%95%E8%AE%A1%E6%95%B0%E6%9F%90%E4%B8%AA%E5%8C%BA%E9%97%B4%E5%86%85%E7%9A%84%E4%B8%AA%E6%95%B0)
D2=COUNTIF(A:A,">=6000")-COUNTIF(A:A,">=8000")
D3=COUNTIF(A:A,">=5000")-COUNTIF(A:A,">=6000")
D4=COUNTIF(A:A,">=4000")-COUNTIF(A:A,">=5000")
D5=COUNTIF(A:A,">=3000")-COUNTIF(A:A,">=4000")
D6=COUNTIF(A:A,">=2000")-COUNTIF(A:A,">=3000")
具体是>=还是>自己看看吧
D3=COUNTIF(A:A,">=5000")-COUNTIF(A:A,">=6000")
D4=COUNTIF(A:A,">=4000")-COUNTIF(A:A,">=5000")
D5=COUNTIF(A:A,">=3000")-COUNTIF(A:A,">=4000")
D6=COUNTIF(A:A,">=2000")-COUNTIF(A:A,">=3000")
具体是>=还是>自己看看吧