内容简介:假如分数在B2:B7单元格区域: 总分:sum(B2:B7) 平均分:average(B2:B7) 60分及以上为及格:countif(B2:B7,">=60")/count(B2:B7) 90分及以上为优秀:countif(B2:B7,">=90")/countB2:B7) excel是一款常用的办公软件,那么如何如何在Excel中计算总分、平均分...
用户评论
voxtech