| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LIST OF THE NUMBERS, AND HOW MANY TIMES THEY REPEAT? | Excel Worksheet Functions | |||
| Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
| Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
| I have a long equation which I need to repeat 16 times! | Excel Worksheet Functions | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Threaded Mode
