如何在Excel中输入及格人数、及格率、
比如：A2:A51为姓名，B2:B51为分数（其中可能有未参考的人，分数为空）。
及格标准：>=60；优秀标准：>=80
及格人数：=COUNTIF(B2:B51,">=60")
实际参考人数及格率：=COUNTIF(B2:B51,">=60")/COUNTA(A2:A51)
应参考人数及格率：=COUNTIF(B2:B51,">=60")/COUNT(B2:B51)
优秀人数：=COUNTIF(B2:B51,">=80")
实际参考人数优秀率：=COUNTIF(B2:B51,">=80")/COUNTA(A2:A51)
应参考人数优秀率：=COUNTIF(B2:B51,">=80")...全部
比如：A2:A51为姓名，B2:B51为分数（其中可能有未参考的人，分数为空）。
及格标准：>=60；优秀标准：>=80
及格人数：=COUNTIF(B2:B51,">=60")
实际参考人数及格率：=COUNTIF(B2:B51,">=60")/COUNTA(A2:A51)
应参考人数及格率：=COUNTIF(B2:B51,">=60")/COUNT(B2:B51)
优秀人数：=COUNTIF(B2:B51,">=80")
实际参考人数优秀率：=COUNTIF(B2:B51,">=80")/COUNTA(A2:A51)
应参考人数优秀率：=COUNTIF(B2:B51,">=80")/COUNT(A2:A51)
答案补充：
cpqxyl1824老师已经作了补充，再予补充似乎多余，但我觉得cpqxyl1824老师的公式是否可以将公式中条件的设置简化为
">=60" 和 ">=90"
所以我的公式是
及格标准：>=60；优秀标准：>=80
及格人数：=COUNTIF(B2:B51:G2:G51,">=60")
实际参考人数及格率：=COUNTIF(B2:B51:G2:G51,">=60")/COUNTA(A2:A51,F2:F51)
应参考人数及格率：=COUNTIF(B2:B51:G2:G51,">=60")/COUNT(B2:B51,G2:G51)
优秀人数：=COUNTIF(B2:B51:G2:G51,">=80")
实际参考人数优秀率：=COUNTIF(B2:B51:G2:G51,">=80")/COUNTA(A2:A51,F2:F51)
应参考人数优秀率：=COUNTIF(B2:B51:G2:G51,">=80")/COUNT(A2:A51,F2:F51)。收起
