查找B2至B100区域小于等于59的个数=COUNTIF(B1:B100,"<=59")查找B2至B100区域小于等于69的个数=COUNTIF(B1:B100,"<=69")-COUNTIF(B1:B100,"<=59")
=count(范围)希望能帮到您。