Question

Excel一列值求指定范围内的个数

请问要算出100-200，200-300，500以上的个数怎么样的公式呢？谢谢

Answer 1

100-200（不含）的个数——在C12单元格里输入：=COUNTIFS(C$1:C$10,">=100",C$1:C$10,"<200")
200-300（不含）的个数——在C13单元格里输入：=COUNTIFS(C$1:C$10,">=200",C$1:C$10,"<300")
500（不含）以上的个数——在C14单元格里输入：=COUNTIF(C$1:C$10,">500")

Answer 2

500以上公式：
=COUNTIF(C1:C10,">500")
100-200公式：=COUNTIF(C1:C10,">=100")-COUNTIF(C1:C10,">=200")

Answer 3

100-200公式：
=COUNTIFS(C$1:C$10,">=100",C$1:C$10,"<200")
200-300公式：
=COUNTIFS(C$1:C$10,">=200",C$1:C$10,"<300")
500以上：
=COUNTIF(C$1:C$10,">=500")