計算60-80分之間的人數(shù),=COUNTIF(A2:A13,">60")-COUNTIF(A2:A13,">80")
計算總?cè)藬?shù):=COUNTA(A2:A13)
算比例:=(COUNTIF(A2:A13,">60")-COUNTIF(A2:A13,">80"))/COUNTA(A2:A13)
小數(shù)換算成百分比:=TEXT(D2,"0.00%")
60-80分人數(shù)占總?cè)藬?shù)的百分比就如下圖:
計算總?cè)藬?shù):=COUNTA(A2:A13)
算比例:=(COUNTIF(A2:A13,">60")-COUNTIF(A2:A13,">80"))/COUNTA(A2:A13)
小數(shù)換算成百分比:=TEXT(D2,"0.00%")
60-80分人數(shù)占總?cè)藬?shù)的百分比就如下圖: