=SUMPRODUCT(s3:gv3*(MOD(column(s3:gv3),6)<>1))
=sum(t3:gv3)-sumproduct((mod(column(t3:gv3),6)=1)*(t3:gv3))
点求和后，可按住CTRL进行叠加选择
