excel countif函数统计80到90分之间的成绩怎么统计啊

先统计>=80 再统计>90 两者相减则为80到90分之间 =COUNTIF(B:B,">=80")-COUNTIF(B:B,">90")