用Excel表格怎么算及格率、优秀率以及优秀人数呢？

及格人数=countif(A1:A23,">=60")+countif(C1:C22,">=60") 优秀人数=countif(A1:A23,">=85")+countif(C1:C22,">=85") 及格率=(countif(A1:A23,">=60")+countif(C1:C22,">=60"))/45 优秀率=(countif(