Skipping certain cells when dragging down cells!

[nathanlindop]

Hello, I'm looking to easily drag the sum of certain cells in a different column BUT keeping a specific range, it's hard to explain so i'll show an example...

[TABLE="width: 300"]
<tbody>[TR]
[TD]A1
A2
A3
A4
A5
A6
A7
A8[/TD]
[TD]B1=SUM(A1:A4)
B2=SUM(A4:A7)
B3=SUM(A8:A11)

And so on...[/TD]
[/TR]
</tbody>[/TABLE]
Is there any way I can do this by dragging down the cell formula from B1 and it remembering the range of 4, so I don't have to manually select each range...?
Thanks

 

[ukmikeb]

Hi

Try :-

=SUM(OFFSET($A$1,(ROWS($A$1:$A1)-1)*3,,4,1))

which includes the last row of the previous set as per the second line of your example.

To start a new set after the fourth line change the 3 in the above to 4.

hth

 

[nathanlindop]

Legend that's worked, Thanks!

 

[ukmikeb]

Hi

Thanks for the feedback.

Pleased to have helped solve your problem.

Good luck with your project.