excel表格数据区间统计?答:可以整列引用:=COUNTIFS(E:E,">=290",E:E,"<=300",B:B,">=100",B:B,"<=105")也可以限制行号范围:=COUNTIFS(E2:E32,">=290",E2:E32,"<=300",B2:B32,">=100",B2:B32,"<=105")
请问如何用Excel函数将各区间的数据个数计算出来?答:建议你在成绩表上多加一列“分数段”,方便你以后做汇总工作。公式:=IF(A2>89,"90-100",IF(A2>79,"80-89",IF(A2>69,"70-79",IF(A2>59,"60-69","0-59")))然后统计90-100的人数=COUNTIF(B:B,"90-100")&"人"统计80-89的人数=COUNTIF(B:B,"80-89")&"人"统计70-79的人数...