先统计>=80 再统计>90
两者相减则为80到90分之间
=COUNTIF(B:B,">=80")-COUNTIF(B:B,">90")
两者相减则为80到90分之间
=COUNTIF(B:B,">=80")-COUNTIF(B:B,">90")
温馨提示：内容为网友见解，仅供参考
第1个回答 2010-03-06
=COUNTIF(数据区域,">＝80")-COUNTIF(数据区域,">＝90")本回答被提问者采纳
第2个回答 2010-03-06
=COUNTIF(A:A,">=80")-COUNTIF(A:A,">90")
相似回答
