How to calculate the sum of the alternate rows?

[Guest]

Hi,

Could you help me in calculating the sum of the alternate rows with out
adding a column or row with intermeditate formula.

Thanks and Regards
satish

 

[Gord Dibben]

To SUM alternate rows in Column A.

=SUMPRODUCT((MOD(ROW($A$1:$A$1004),2)=MOD(ROW($A$1)-1,2))*($A$1:$A$1004))

To SUM alternate rows in Columns A and B

=SUMPRODUCT((MOD(ROW($A$1:$B$1004),2)=MOD(ROW($A$1)-1,2))*($A$1:$B$1004))


Gord Dibben MS Excel MVP

 

[Guest]

Hi,

Thank you very much. It works.

Regards
satish.