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

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:
I want to make a summary sheet which shows in D2:F30, respectively each 20 rows SUM cells in it.
For example Result D20 in sheet 1, in D2 of sheet2.
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.

If there is any formula, I can use rather than create repeatedly all the links one by one, I would appreciate it to help me.

Cheers.

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

Try this:

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

HTH
Elkar


"Iraj" wrote:

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:
I want to make a summary sheet which shows in D2:F30, respectively each 20 rows SUM cells in it.
For example Result D20 in sheet 1, in D2 of sheet2.
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.

If there is any formula, I can use rather than create repeatedly all the links one by one, I would appreciate it to help me.

Cheers.

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

Dear Elkar:
Great formula, works perfectly, Thanks

Iraj.

"Elkar" wrote:

Try this:

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

HTH
Elkar


"Iraj" wrote:

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:
I want to make a summary sheet which shows in D2:F30, respectively each 20 rows SUM cells in it.
For example Result D20 in sheet 1, in D2 of sheet2.
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.

If there is any formula, I can use rather than create repeatedly all the links one by one, I would appreciate it to help me.

Cheers.