1、分数段人数统计
90-100分：=COUNTIF(C4:C18,\">=90\")
80-89分：=COUNTIF(C4:C18,\">=80\")-COUNTIF(C4:C18,\">=90\") 70-79分：=COUNTIF(C4:C18,\">=70\")-COUNTIF(C4:C18,\">=80\") 60-69分：=COUNTIF(C4:C18,\">=60\")-COUNTIF(C4:C18,\">=70\") 50-59分：=COUNTIF(C4:C18,\">=50\")-COUNTIF(C4:C18,\">=60\") 41-49分：=COUNTIF(C4:C18,\">40\")-COUNTIF(C4:C18,\">=50\") 40分及以下：=COUNTIF(C4:C18,\"<=40\")
2、最高分：=MAX(C4:C18,G4:G18,K4:K18,O4:O13) 最低分：=MIN(C4:C18,G4:G18,K4:K18,O4:O13) 总分：=SUM(C4:C18,G4:G18,K4:K18,O4:O13) 平均分：=AVERAGE(B4:D4)
3、与考人数、记分人数：=COUNT(C4:C18,G4:G18,K4:K18,O4:O18)
因篇幅问题不能全部显示，请点此查看更多更全内容