Help Dragging a Formula with Cell Reference Greater than 1

[djanders]

I have a worksheet with two tabs, T-Requests and Weekly Totals. The T-Requests tab has daily data for every day. On the weekly totals tab, I have cells set up for each week and need them to sum up a specific week's data from the T-Requests tab. My problem is on the Weekly Totals tab, I want to drag the formulas to all of the weeks so I don't have to individually change a cell's formula 52 times. I've looked around Google and can't find exactly what I'm looking for. Can someone help? For example, here is how the formula will look for two adjacent cells:

=SUM('Filing - Contracts'!F7:L7)+SUM('Filing - Title'!F7:L7) for the first cell
=SUM('Filing - Contracts'!M7:S7)+SUM('Filing - Title'!M7:S7) for the adjacent cell, and so on....

So, I just need a simpler way to increase the cell reference by 5 each time without having to manually change them

[ChemistB]

Are you dragging down or across?

[ChemistB]

Assuming you are dragging down, try something like this

Please Login or Register  to view this content.

[djanders]

Assuming you are dragging down, try something like this

Please Login or Register  to view this content.

Thanks for the help. I'm actually dragging across, so how would that change it?

[ChemistB]

=SUM(OFFSET('Filing - Contracts'!$F$7:$L$7, 0,(COLUMNS($B$1:B$1)-1)*5))+SUM(OFFSET('Filing - Title'!$F$7:$L$7,0,(COLUMNS($B$1:B$1)-1)*5))
Changed "Rows" to "Columns" and modified the anchors.

[djanders]

=SUM(OFFSET('Filing - Contracts'!$F$7:$L$7, 0,(COLUMNS($B$1:B$1)-1)*5))+SUM(OFFSET('Filing - Title'!$F$7:$L$7,0,(COLUMNS($B$1:B$1)-1)*5))
Changed "Rows" to "Columns" and modified the anchors.

Awesome. That worked. Thank you