Drag down formula but range remain consistent

[kayafueya]

Hello. I need help with this. I want to drag down the formula of of my 1st cell but it doesn't work. the formula is =SUM('RAW DATA'!B2:B6).

What I want is when I drag down, it will become =SUM('RAW DATA'!B7:B11)

but instead it becomes =SUM('RAW DATA'!B3:B7). how to make this work?

[kayafueya]

Please help

[AliGW]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only ten minutes since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[Bo_Ry]

Please try at B3
Non-volatile

=SUM(INDEX('RAW DATA'!B:B,ROWS(B$3:B3)*5-3):INDEX('RAW DATA'!B:B,ROWS(B$3:B3)*5+1))

or volatile
=SUM(OFFSET('RAW DATA'!$B$2,ROWS(B$3:B3)*5-5,,5))

[kayafueya]

Thank you so much man! I'm still having a hard time understanding the formula but it works.

[kayafueya]

Im sorry bout it. Thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.