Hi All
Possibly a very simple question, but has stumped me, so I hope someone can help.
In Sheet1 I have each day from 01/04/04 up to 31/03/05 (one day per row). I have a number of columns, each of which is filled with figures corresponding to all the days.
In Sheet2 I want the same columns headings, but instead of being split daily I want ithe sums of the weekly figures.. In my particular sheet, the first cell is going to be C2 and could simply be put as =SUM(Sheet1!B2:B8). C3 would then be =SUM(Sheet1!B9:B15), while D2 would be =SUM(Sheet1!C2:C8), and so on along and down.
The problem is that when I try to copy down =SUM(Sheet1!B2:B8) I get =SUM(Sheet1!B3:B9). Is there any formula that I can enter that I can put into C2 and then copy down and copy along to give me the right ranges?
I have looked through the message board for ages but can't find anybody else with quite the same problem.
Thanks for your help
Possibly a very simple question, but has stumped me, so I hope someone can help.
In Sheet1 I have each day from 01/04/04 up to 31/03/05 (one day per row). I have a number of columns, each of which is filled with figures corresponding to all the days.
In Sheet2 I want the same columns headings, but instead of being split daily I want ithe sums of the weekly figures.. In my particular sheet, the first cell is going to be C2 and could simply be put as =SUM(Sheet1!B2:B8). C3 would then be =SUM(Sheet1!B9:B15), while D2 would be =SUM(Sheet1!C2:C8), and so on along and down.
The problem is that when I try to copy down =SUM(Sheet1!B2:B8) I get =SUM(Sheet1!B3:B9). Is there any formula that I can enter that I can put into C2 and then copy down and copy along to give me the right ranges?
I have looked through the message board for ages but can't find anybody else with quite the same problem.
Thanks for your help