EXCEL跳跃相同间距的单元格求和
发布网友
共2个回答
热心网友
假定总行数小于等于1000
=SUMPRODUCT((MOD(ROW(A1:A1000),3)=1)*A1:A1000)
假定总行数小于等于100000
=SUMPRODUCT((MOD(ROW(A1:A100000),3)=1)*A1:A100000)
热心网友
=SUMPRODUCT(A1:A1000*(MOD(ROW($1:$1000),3)=1))
