Offset formula help

[tealy1980]

Hi all,

I have a quick question about the offset formula, pretty basic I think nut I'm a novice!

So I have a spreadsheet, summarised like so:

I want to sum the weeks by period, is there anyway to use offset so when I drag the formula across it wont just move one column at a time, but rather by 4 weekly blocks??

Many thanks in advance.

p1	p2	p3	p4
4	8	xxx	xxx
week 1	week 2	week 3	week 4	week 5	week 6	week 7	week 8
1	1	1	1	2	2	2	2

<tbody>
</tbody>

 

[ukmikeb]

tealy1980

The formula would be entered in A2 and would be modified to :-

=SUM(OFFSET($A$4,,(COLUMNS($A:A)-1)*4,1,4))

and dragged across.

@AndyPandy27 A tad overexpression to get the end result if I may say! Why apply a row offset when you can anchor the cell?