比如我要求A1,B1,C1, ,E1,F1,G1, ,I1,J1,K1,,M1,N1,O1,,Q1,R1,S1......之类每三列隔一列的求和函数
=SUMPRODUCT(A1:L1,ROUNDUP(MOD(COLUMN(A1:L1),4)/4,0))
A1至W1中除D1、E1、I1,J1,N1,O1,S1,T1外的数值求和(每三列隔两列)之类的呢?
=SUMPRODUCT(A1:O1,ROUNDUP(MOD(COLUMN(A1:O1)+1,5)/5,0),ROUNDUP(MOD(COLUMN(A1:O1),5)/5,0))