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

A1 A2 A3 A4 A5 A6 A7 A8

B1=SUM(A1:A4) B2=SUM(A4:A7) B3=SUM(A8:A11) And so on...

<tbody>
</tbody>

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).