excel中用函数统计出某个区间有几个数

2025-03-28 22:04:17
推荐回答(2个)
回答1:

查找B2至B100区域小于等于59的个数
=COUNTIF(B1:B100,"<=59")
查找B2至B100区域小于等于69的个数
=COUNTIF(B1:B100,"<=69")-COUNTIF(B1:B100,"<=59")

回答2:

=count(范围)
希望能帮到您。