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
|