期末考试成绩最近会出来了,各位老师需要对自己班上各个分段数学生数量有所了解,今天为大家介绍一种简便有效的统计方法。
方法
假设一组数据。
更具自己需要,设置分段数。
在C2框内输入
=COUNTIF($A$2:$A$10,">=0")-COUNTIF($A$2:$A$10,">60")
在C3单元格内输入
=COUNTIF($A$2:$A$10,">=60")-COUNTIF($A$2:$A$10,">70")
在C4单元格内输入
=COUNTIF($A$2:$A$10,">=70")-COUNTIF($A$2:$A$10,">80")
在C5单元格内输入
=COUNTIF($A$2:$A$10,">=80")-COUNTIF($A$2:$A$10,">90")
在C6单元格内输入
=COUNTIF($A$2:$A$10,">=90")-COUNTIF($A$2:$A$10,">=100")
分数段统计就完成啦!
声明:本文由用户 wx47314506 上传分享,本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:0731-84117792 E-MAIL:11247931@qq.com