excel统计80~90分的人数，如何操作？

Question

如题所述

Answer 1

假设分数写在B列\x0d\x0a03及以上版本公式\x0d\x0a=COUNTIF(B:B,">=80")-COUNTIF(B:B,">90")\x0d\x0a \x0d\x0a=SUMPRODUCT((B1:B1000>=80)*(B1:B1000<=90))\x0d\x0a \x0d\x0a07及以上版本公式\x0d\x0a=COUNTIFS(B:B,">=80",B:B,"<=90")