Hi all! I've googled but still can't find a way to do this.
I have 2 worksheets, Sheet1 where information is entered and Sheet2 which extracts the info.
In Sheet2 my formulas are therefore as follows:
D1=SUM(Sheet1!D7:A8)+SUM(Sheet1!D63:D64)
D2=SUM(Sheet1!D119:D120)+SUM(Sheet1!D175:D176)
D3=SUM(Sheet1!D231:D232)+SUM(Sheet1!D287:D288)
etc...
I need to continue this pattern downwards for 50-100 rows. Clicking and dragging simply increases the increment by 1 instead of 56 like I would need. Is there any way of simplifying this, as I don't really want to do this manually if possible?!!
Thanks in advance!
Bookmarks