R rob Jul 30, 2003 #1 How do I create a formula to tell Excel to sum every other row in a column? Thank you for your assistance
How do I create a formula to tell Excel to sum every other row in a column? Thank you for your assistance
E EarlK Jul 30, 2003 #2 Rob, This is for even numbered rows. Change 0 to 1 for odd numbered rows. =SUMPRODUCT((MOD(ROW(B2:B8),2)=0)*(B2:B8))
Rob, This is for even numbered rows. Change 0 to 1 for odd numbered rows. =SUMPRODUCT((MOD(ROW(B2:B8),2)=0)*(B2:B8))
