=COUNTIF(B1:C21,"<70")-COUNTIF(B1:C21,"<=60")选求出小于70的单元格的个数再减去小于或等于60的单元格的个数就行了.

=countif(A1:A100,">=60")-countif(A1:A100,">=80")

=COUNTIFS(D:D,">60",D:D,"<70")

excel的countif函数要表示小于70大于60应怎么做。countif函数只是统计符合条件的单元格的个数，你要求小于70且大于60的单元格的个数，可以这样求（假设你的数据区域在B1至C21）=COUNTIF(B1:C21,"<70")-COUNTIF(B1:C21,...

=COUNTIF(F3:F7,">=90")或=COUNTIF(G3:G7,"优秀")良好人数=COUNTIF(F3:F7,">=75")-COUNTIF(F3:F7,">=90")或=COUNTIF(G3:G7,"良好")合格人数=COUNTIF(F3:F7,">

假如数据是在A列，那么在其他列的一个单元格中输入如下公式即可：=COUNTIF(A:A,"<70")-COUNTIF(A:A,"<=60")GoodLuck!

如图，统计A1:A5区域大于10又小于100的个数，公式=COUNTIFS(A1:A5,">10",A1:A5,"<100")示例

1、首先在excel表格中输入一组数据，该组数据有负值有小数数值，需要在该组数据中计算大于-100并且小于0.1的个数。2、在B1单元格中输入计算公式：=COUNTIFS(A1:A6,">-100",A1:A6,"<0.1")，需要在两个条件的前方都...

=COUNTIF(统计区域,">比较数字")统计区域中大于比较数字的个数，如：=COUNTIF(A:A,">18")统计A列大于18的数字个数统计小于时，把比较符改成小于符：=COUNTIF(A2:C100,"<60")统计A2:C100中小于60的个数。

比如你要求A1到D5中大于60小于90的人数，你只需要用小于90的个数-小于60的个数。具体公式表达如下：=COUNTIF(A1:D5,"《90")-COUNTIF(A1:D5,"《=60")回答满意给我分吧谢谢...