你好，请问excel表，G、j、M、P四列相加再去掉一个最高分和一个最低分的公式怎么做？谢谢！

Question

如题所述

Answer 1

=SUMPRODUCT(SMALL((MOD(COLUMN(G2:P2),3)=1)*G2:P2,{2,3}+6))

Answer 2

=SMALL((G2,J2,M2,P2),2)+LARGE((G2,J2,M2,P2),2)
或
=SUM(G2,J2,M2,P2)-MIN(G2,J2,M2,P2)-MAX(G2,J2,M2,P2)