計算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分人數占總人數的百分比就如下圖:
計算總人數:=COUNTA(A2:A13)
算比例:=(COUNTIF(A2:A13,">60")-COUNTIF(A2:A13,">80"))/COUNTA(A2:A13)
小數換算成百分比:=TEXT(D2,"0.00%")
60-80分人數占總人數的百分比就如下圖: