假定A1:A8存放8位工人的劳动量,
b1:d1为标题:劳动量 频数(人) 频数(%)
b2="80~90"
b3="90~100"
则:
C2=COUNTIF($A$1:$A$8,"<=90")-COUNTIF($A$1:$A$8,"<=80")
C3=COUNTIF($A$1:$A$8,"<=100")-COUNTIF($A$1:$A$8,"<=90")
D2=C2/COUNT($A$1:$A$8)
D3=C3/COUNT($A$1:$A$8)
D2和D3的单元格格式,取为“百分比”
温馨提示:答案为网友推荐,仅供参考