假设成绩数据在A1:A100 ,假设90分以上为优秀优秀人数公式：=countif(A1:A100,">=90")优秀率公式=countif(A1:A100),">=90")/count(A1:A100)
