Question

Excel在一组数据中查找指定范围内的数值有几个

比如1,2,3,4,5^100,在其中大于1 小于20的数有几个，大于20小于40数有几个

Answer 1

如果数据是规范储存的数据，比如在a1到a100中，就很简单，直接参考：
=COUNTIFS(A1:A100,">1",A1:A100,"<20")
=COUNTIFS(A1:A100,">20",A1:A100,"<40")

如果条件1在b1单元格，20在b2参考
=COUNTIFS(A1:A100,">"b1,A1:A100,"<"&b2)

Answer 2

如果数据是规范储存的数据，比如在a1到a100中，就很简单，直接参考：
=COUNTIFS(A1:A100,">1",A1:A100,"<20")
=COUNTIFS(A1:A100,">20",A1:A100,"<40")

如果条件1在b1单元格，20在b2参考
=COUNTIFS(A1:A100,">"b1,A1:A100,"<"&b2)