Dragging consecutive ranges

[mcallaghnk]

Not sure where this should really be, but here is my issue:

I am attempting to drag:
=SUM('January 2016'!B3:B6)

into:
=SUM('January 2016'!B7:B10)

and so on. But all I am getting is:
=SUM('January 2016'!B4:B7)

I feel like I'm missing something obvious. Any ideas?

Thanks in advance.

[BadlySpelledBuoy]

Could we see an example workbook? It would make it far easier to understand your need.

Desensitize any sensitive data and show expected results where possible.

BSB

[FDibbins]

What exactly are you trying to do?

You are not missing anything, if you drag a reference to B3 to the next cell over, you will get a reference to B4 - no-way will you ever get it to reference B7 just by draging that across

[jason.b75]

Maybe

=SUM(OFFSET('January 2016'!$B$3,(ROWS(A$1:A1)-1)*4,0,4,1))

[mcallaghnk]

Thanks Jason, that has helped me no end. Everything is working perfectly. The only issue I have now is working out how your formula works for the future