电子表格去掉5个最低分求总分和平均分求总分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))平均分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))/(COUNT
来源：学生作业帮助网 编辑：六六作业网 时间：2024/12/26 23:21:45
电子表格去掉5个最低分求总分和平均分求总分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))平均分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))/(COUNT
电子表格去掉5个最低分求总分和平均分
求总分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))
平均分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))/(COUNT(C5:C28,G5:G28,K5:K28)-5)
为何在没有输入数值的时候显示的结果是总分是-135、平均分是27.0而不是0呢?如图.
电子表格去掉5个最低分求总分和平均分求总分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))平均分函数 =SUM(C5:C28,G5:G28,K5:K28,-SMALL($C$5:$C$28:$G$5:$G$28:$K$5:$K$28,{1,2,3,4,5}))/(COUNT
是SMALL的引用问题,当你要求5个最小时,要有5个或以上的数据给他,要不它就将E\F列的数据给算进去了.
总分-135正好等于25+26+27+28+29的和,就是E/I两列的5个最小值.