excel中countif函数大于等于80且小于等于90如何输入?
发布网友
发布时间:2022-04-24 02:43
我来回答
共1个回答
热心网友
时间:2023-10-22 17:04
COUNTIF无法多条件计数,可用两个函数相减:
=COUNTIF(A:A,"<=90")-COUNTIF(A:A,"<80")
如果是2007版或2010版,可用COUNTIFS。
=COUNTIFS(A:A,">=80",A:A,"<=90")
03版也可用
=SUMPRODUCT((A1:A100>=80)*(A1:A100<=90))
热心网友
时间:2023-10-22 17:04
COUNTIF无法多条件计数,可用两个函数相减:
=COUNTIF(A:A,"<=90")-COUNTIF(A:A,"<80")
如果是2007版或2010版,可用COUNTIFS。
=COUNTIFS(A:A,">=80",A:A,"<=90")
03版也可用
=SUMPRODUCT((A1:A100>=80)*(A1:A100<=90))
热心网友
时间:2023-10-22 17:04
COUNTIF无法多条件计数,可用两个函数相减:
=COUNTIF(A:A,"<=90")-COUNTIF(A:A,"<80")
如果是2007版或2010版,可用COUNTIFS。
=COUNTIFS(A:A,">=80",A:A,"<=90")
03版也可用
=SUMPRODUCT((A1:A100>=80)*(A1:A100<=90))