Hi all, first post.
If this has already been asked, please send me a link but I have searched and found nothing.

I want to create a formula so that when I drag it down to apply to multiple cells the range in the formula increases at say an interval of 5 rather than 1. So it continues from where the previous cell finished.

For example, if in cell A1 I had:
=SUM(B1:B5)

I'd want cell A2 to have:
=SUM(B6:B10)

Rather than:
=SUM(B2:B6)

I hope that illustrates what I'm after as I can't think of a better way to word it!

Thanks in adance for any help!