标签：Excel学习,excel视频教程,http://www.qiuzhi56.com 使用EXCEL的countif函数时怎样输入两个条件?,http://www.qiuzhi56.com

=COUNTIF(A1:A20,">=240")-COUNTIF(A1:A20,"<270")
用这样的公式就行了。

不好意思，写错了，应该是
=COUNTIF(A1:A20,">=240")-COUNTIF(A1:A20,">270")
才对，就是大于等于240的数字个数减去大于270的数字个数，剩下的不就是你需要的范围内的数字个数了么？


=countif(a:a,">=240")-countif(a:a,">=270")

=COUNTIF(A1:A20,">=240")-COUNTIF(A1:A20,"<270")

excel用countif函数输范围时怎么输：如即小于等于60又大于等于50怎么输？

=COUNTIF(A1:A5,"<=60")-COUNTIF(A1:A5,"<50")

，使用EXCEL的countif函数时怎样输入两个条件?