SUMPRODUCT乘积求和。mod求余，row提取行数=SUMPRODUCT(A1:A125*(MOD(ROW(A1:A125),4)=1))
=SUMPRODUCT(A1:A125*(MOD(ROW(A1:A125),4)=1))
同意1楼回答。另下面办法也可以：=SUM(A1，A5，A9，.......，A125）
=SUM(A1:4:A13)试试行不行
