=SUMPRODUCT((MOD(COLUMN(A1:Z1),2)=1)*A1:Z1)或=SUMPRODUCT(MOD(COLUMN(A1:Z1),2)*A1:Z1)结果是求A1:Z1奇数列数据的和=SUMPRODUCT((MOD(COLUMN(A1:Z1),2)=0)*A1:Z1)结果是求A1:Z1偶数列数据的和
