如何在excel中利用函数公式计算某一学科排名前10名成绩优秀率

及格人数 =COUNTIF(A2:A21,">90") 及格率 =COUNTIF(A2:A21,">90")/COUNTA(A2:A21) 优秀人数 =COUNTIF(A2:A21,">120") 前10名成绩优秀率 =MIN(COUNTIF(A2:A21,">120"),10)/10 平均分 =AVERAGE(A2:A21) A2:A21为数据区域