How to calculate the sum of the alternate rows?
 

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

How to calculate the sum of the alternate rows?
 

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


On Wed, 21 Jun 2006 12:17:03 -0700, Sathish
wrote:

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

How to calculate the sum of the alternate rows?
 

Hi,

Thank you very much. It works.

Regards
satish.

"Gord Dibben" wrote:

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


On Wed, 21 Jun 2006 12:17:03 -0700, Sathish
wrote:

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