An alternative is to use the `=OFFSET()`

function to define your summand.

For example `OFFSET(F1,0,add_col,rows_to_sum,1)`

defines a range 1 column wide which starts at `add_col`

columns to the right of cell `F1`

extends `row_to_sum`

rows downwards, so

`OFFSET(F1,0,0,10,1)`

is equivalent to `F1:F10`

`OFFSET(F1,0,0,20,1)`

is equivalent to `F1:F20`

`OFFSET(F1,0,1,10,1)`

is equivalent to `G1:G10`

`OFFSET(F1,0,1,20,1)`

is equivalent to `G1:G20`

`add_col`

and `rows_to_sum`

can be suitable cell references e.g. `A1`

, `D2`

etc.

Simply wrap the `OFFSET()`

within a `=SUM()`

to get something like `=SUM(OFFSET(F1,0,A1,D2,1))`

using relative/absolute cell references ($ signs) as appropriate.

If you don't always wish to start summation from the first worksheet row then use a value other than 0 for the second argument of the `OFFSET()`

function. For example:

`OFFSET(F1,6,0,14,1)`

is equivalent to `F7:F20`

and again a cell reference can be used for this second argument.

Similarly, if you want to make the summation cover multiple columns then use a value other than 1 for the fifth argument of the `OFFSET()`

function. For example:

`OFFSET(F1,6,0,14,2)`

is equivalent to `F7:G20`

and again a cell reference can be used for this fifth argument.

See https://support.microsoft.com/en-us/office/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66 for details about worksheet function `=OFFSET()`