excel算平均值,50多个评委,去掉比较高的三个分数,和三个比较低的分数,然后求平均值,怎么算啊?

把数据放在A栏：除A栏以外的任意位置输入
=(SUM($A$1:$A$65535)-SUM(SMALL($A$1:$A$65535,1),SMALL($A$1:$A$65535,2),SMALL($A$1:$A$65535,3),LARGE($A$1:$A$65535,1),LARGE($A$1:$A$65535,2),LARGE($A$1:$A$65535,3)))/(COUNT($A$1:$A$65535)-6)