如题所述
计算60-80分之间的人数,=COUNTIF(A2:A13,">60")-COUNTIF(A2:A13,">80")
计算总人数:=COUNTA(A2:A13)
算比例:=(COUNTIF(A2:A13,">60")-COUNTIF(A2:A13,">80"))/COUNTA(A2:A13)
小数换算成百分比:=TEXT(D2,"0.00%")
60-80分人数占总人数的百分比就如下图: