用countif函数统计各分数段的人数。
=COUNTIF(C$2:C$21,>=90) =COUNTIF(D$2:D$21,>=90) =COUNTIF(E$2:E$21,>=90)
=COUNTIF(C$2:C$21,>=80)-COUNTIF(C$2:C$21,>=90) =COUNTIF(D$2:D$21,>=80)-COUNTIF(D$2:D$21,>=90) =COUNTIF(E$2:E$21,>=80)-COUNTIF(E$2:E$21,>=90)
=COUNTIF(C$2:C$21,>=70)-COUNTIF(C$2:C$21,>=80) =COUNTIF(D$2:D$21,>=70)-COUNTIF(D$2:D$21,>=80) =COUNTIF(E$2:E$21,>=70)-COUNTIF(E$2:E$21,>=80)
=COUNTIF(C$2:C$21,>=60)-COUNTIF(C$2:C$21,>=70) =COUNTIF(D$2:D$21,>=60)-COUNTIF(D$2:D$21,>=70) =COUNTIF(E$2:E$21,>=60)-COUNTIF(E$2:E$21,>=70)
=COUNTIF(C$2:C$21,<60) =COUNTIF(D$2:D$21,<60) =COUNTIF(E$2:E$21,<60)