excel怎么计算总分，平均分，及格率，优秀率

假如分数在B2:B7单元格区域： 总分：sum(B2:B7) 平均分：average(B2:B7) 60分及以上为及格：countif(B2:B7,">=60")/count(B2:B7) 90分及以上为优秀：countif(B2:B7,">=90")/countB2:B7)