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