六 122008
假设数据在A1:A100
奇数行:
=SUMPRODUCT(MOD(ROW($A$1:$A$100),2)*$A$1:$A$100)
偶数行:
=SUMPRODUCT((MOD(ROW($A$1:$A$100),2)=0)*($A$1:$A$100))
One Response to “EXCEL奇数行或偶数行求和”
Comments (1)
假设数据在A1:A100
奇数行:
=SUMPRODUCT(MOD(ROW($A$1:$A$100),2)*$A$1:$A$100)
偶数行:
=SUMPRODUCT((MOD(ROW($A$1:$A$100),2)=0)*($A$1:$A$100))
好像缺了B列的数据，因为这个函数是计算两列乘积的和。
数行:
=SUMPRODUCT(MOD(ROW($A$1:$A$100),2)*$A$1:$A$100,$B$1:$B$100)
偶数行:
=SUMPRODUCT((MOD(ROW($A$1:$A$100),2)=0)*($A$1:$A$100),$B$1:$B$100)