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!
Bookmarks