检测质量分析常用函数，以单元格F3到F34为例：总分=SUM(F3:F34)
平均分=AVERAGE(F3:F34)
及格人数=COUNTIF(F3:F34,">=60")
优秀人数=COUNTIF(F3:F34,">=85")
优生率=COUNTIF(F3:F34,">=85")/COUNT(F3:F34)
及格率=COUNTIF(F3:F34,">=60")/COUNT(F3:F34)
最高=MAX(F3:F34)
最低=MIN(F3:F34)
0分=COUNTIF(F3:F34,"=0")
分数段=COUNTIFS(F3:F34,">=1",F3:F34,"<=9.9")
分数段=COUNTIFS(F3:F34,">=10",F3:F34,"<=19.9")
分数段=COUNTIFS(F3:F34,">=20",F3:F34,"<=29.9")
countifs函数为何总为零分数段=COUNTIFS(F3:F34,">=30",F3:F34,"<=39.9")
分数段=COUNTIFS(F3:F34,">=40",F3:F34,"<=49.9")
分数段=COUNTIFS(F3:F34,">=50",F3:F34,"<=59.9")
分数段=COUNTIFS(F3:F34,">=60",F3:F34,"<=69.9")
分数段=COUNTIFS(F3:F34,">=70",F3:F34,"<=79.9")
分数段=COUNTIFS(F3:F34,">=80",F3:F34,"<=89.9")
分数段=COUNTIFS(F3:F34,">=90",F3:F34,"<=99.9")
100分=COUNTIF(F3:F34,"=100")
【注意】
1.括号必须是英文输入法下的( )，不是中文输入法下的（）。
2.及格分按60分，优秀按85分

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。