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

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

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