怎样用Excel求N 个数去掉最高值最低值,再求平均值？

假设数据在A2:A18单元格区域
在B2中输入或复制粘贴下列公式
=IF(COUNT(A2:A999)<=7,(SUM(A2:A999)-MAX(A2:A999)-MIN(A2:A999))/COUNT(A2:A999),IF(COUNT(A2:A999)<=12,(SUM(A2:A999)-MAX(A2:A999)-LARGE(A2:A999,2)-MIN(A2:A999)-SMALL(A2:A999,2))/COUNT(A2:A999),IF(COUNT(A2:A999)<=17,(SUM(A2:A999)-MAX(A2:A999)-LARGE(A2:A999,2)-LARGE(A2:A999,3)-MIN(A2:A999)-SMALL(A2:A999,2)-SMALL(A2:A999,3))/COUNT(A2:A999),"")))
或
=IF(COUNT(A2:A999)>17,"",(SUM(A2:A999)-IF(COUNT(A1:A999)<=7,SUM(LARGE(A2:A999,1),SMALL(A2:A999,1)),IF(COUNT(A1:A999)<=12,SUM(LARGE(A2:A999,{1,2}),SMALL(A2:A999,{1,2})),IF(COUNT(A1:A999)<=12,SUM(LARGE(A2:A999,{1,2,3}),SMALL(A2:A999,{1,2,3}))))))/COUNT(A2:A999))