excel表格来自中隔行求和肿么操作

=sumproduct(数据列*(mod(360问答row(),2)=0))隔1行偶数a2,a4,a6…=sumproduct(数据列*(mod(row(),3)=1))割2行齐数a1,a4,a7…