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

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

 

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