使用EXCEL的countif函数时怎样输入两个条件，如大于等于240，小于270

后勤部长 · 发表于 2011-1-5 03:15

=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")