I don't like to repeat this formula 30 times in Excel 2007.

[Iraj]

Hi ALL:
I have in sheet 1:

In every 20 rows, D20,E20,F20 with the respective Auto Sum result up to F600. It means 30 SUM result rows.

In sheet 2:

Result E20 in sheet 1, in E2 of sheet 2.
Result F20 in sheet 1, in F2 of sheet 2.
And so on up to row 600 from sheet 1 to the row 30 in sheet 2 respectively.

Cheers.

 

[Elkar]

Try this:

=INDIRECT("'Sheet1'!"&ADDRESS((ROW()-1)*20,COLUMN()))

HTH
Elkar

 

[Iraj]

Dear Elkar:
Great formula, works perfectly, Thanks

Iraj.