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的人数=COUNTIF(B:B,"70-79")&‘人"统计60-69的人数=COUNTIF(B:B,"60-69")&‘人"统计0-59的"/> 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的人数=COUNTIF(B:B,"70-79")&‘人"统计60-69的人数=COUNTIF(B:B,"60-69")&‘人"统计0-59的"/>
区间数值个数统计方法建议你在成绩表上多加一列“分数段”,方便你以后做汇总工作。=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的人数=COUNTIF(B:B,"70-79")&‘人"统计60-69的人数=COUNTIF(B:B,"60-69")&‘人"统计0-59的...