学生成绩表(计算).xlsx

一年级成绩表学号姓名语文数学英语综合总分平均分名次A0001苏明发112136119240607151.89A0002林平生135128136219618154.57A0003董一敏126140126225617154.38A0004李玉婷109121141271642160.52A0005谭晓婷137107124236604151.010A0006金海莉118123138259638159.53A0007肖友海120119140249628157.06A0008邓同智105117139273634158.54A0009朱仙明118106142268634158.54A0010朱兆祥113134101229577144.311A0011王晓芬124131107281643160.81统计总分大于630的人数：5 对总分大于630的单元格求和：3191等级良良良优良优优优优及格优一年级成绩表学号姓名语文数学英语综合总分平均分A0001苏明发112136119240A0002林平生135128136219A0003董一敏126140126225A0004李玉婷109121141271A0005谭晓婷137107124236A0006金海莉118123138259A0007肖友海120119140249A0008邓同志105117139273A0009朱仙明118106142268A0010朱兆祥113134101229A0011王晓芬124131107281