mdsk.net
当前位置:首页 >> ExCEl CountiF怎么统计大于60小于90分的人数,怎么... >>

ExCEl CountiF怎么统计大于60小于90分的人数,怎么...

=countif(a1:a9,">=60")-countif(a1:a9,">=90")

具体是什么条件,区分对待,03版不能实现多条件,如果是07以上版本,可用countifs函数完成,这个函数是专门为多条件统计实现的。03版可用sumproduct函数来实现=sumproduct((区域1=条件1)*(区域2=条件2)),这里的区域是一样多行数的。否则出错。...

如图,计算A列中分数在80~90之间的人数。 在B1中输入“=COUNTIF(A1:A20,">=80")-COUNTIF(A1:A20,">=90")”即可。

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

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

假设数据区A1:A12 =COUNTIF(A1:A12,">=80")-COUNTIF(A1:A12,">90")=SUMPRODUCT(((A1:A15)>80)*((A1:A15)10并且=10并且

=COUNTIF(B1:C1,">=90") 其中B1:C1为要计算的区域,你可以重新根据需要定义

假设数据区A1:A12 =COUNTIF(A1:A12,">=80")-COUNTIF(A1:A12,">90") =SUMPRODUCT(((A1:A15)>80)*((A1:A15)

1 countif+sum组合 =SUM(COUNTIF(A1:A10,{">=80",">90"})*{-1,1}) 2 sumproduct函数法 =SUMPRODUCT((A1:A10>20)*(A1:A1080)*(A1:A10

版本COUNTIFS可用的话,用:=COUNTIFS(W3:W1979,">-100",W3:W1979,"-100")-COUNTIF(W3:W1979,">=0.1")

网站首页 | 网站地图
All rights reserved Powered by www.mdsk.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com