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.
<tbody>
</tbody>
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>