Adding cells over a specific range!

[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="class: cms_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

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/excel-...g-certain-cells-when-dragging-down-cells.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).