How to Increase cell ranges formula

[Bazman170]

First time poster. Hopefully, I'll make sense.

In cell d49 I have +sum(fixture!l2:m11)
In cell e49 I have +sum(fixture!112:m21)

How do I write a formula to increase this across each cell value by 10? ie: f49 = shows a range of l22:m31 etc, I need to go across to column ao49

Any help more than welcome, self taught on excel and old!!

Need to do this for about 15 rows, so could do with advise, many thanks

 

[nardagus]

Would it be possible to make a Helper Row?
Since you want to increase row address by 10 for each formula you could do this:

In a sheet where you want to put formulas, in a (lets say first row) you place values:

Excel 2016 (Windows) 32 bit

	D	E	F	G	H	I	J	K	L	M	N	O	P	Q

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]130[/TD]

</tbody>

Sheet2​

You need to autofill this row until AO column

Then you could write this formula:

Excel 2016 (Windows) 32 bit

	D	E	F	G

<tbody>
[TD="align: center"]49[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]D49[/TH]
[TD="align: left"]=+SUM(INDIRECT("fixture!L"&2+D$1&":M"&11+D$1))[/TD]
[/TR]
[TR]
[TH]E49[/TH]
[TD="align: left"]=+SUM(INDIRECT("fixture!L"&2+E$1&":M"&11+E$1))[/TD]
[/TR]
[TR]
[TH]F49[/TH]
[TD="align: left"]=+SUM(INDIRECT("fixture!L"&2+F$1&":M"&11+F$1))[/TD]
[/TR]
[TR]
[TH]G49[/TH]
[TD="align: left"]=+SUM(INDIRECT("fixture!L"&2+G$1&":M"&11+G$1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

and also autofill until AO column.
Note that row number is locked so if you copy cells from D49 to AO49 do next row formulas will adjust themselves.

P.s. Values in second table are random as I tested if formulas work.

 

[Bazman170]

Thank you,done the trick

 

[nardagus]

You're welcome.