总分:
平均分:
100-80:=COUNTIF(C3:C104,">=80")
79-70:=COUNTIF(C3:C104,">=70")-COUNTIF(C3:C104,">=80")
69-60:=COUNTIF(C3:C104,">=60")-COUNTIF(C3:C104,">=70")
59-40:=COUNTIF(C3:C104,">=40")-COUNTIF(C3:C104,">=60")
39分以下:=COUNTIF(C3:C104,"<=39")< /P>
最高分:=MAX(C3:C104)
最低分:=MIN(C3:C104)