 # Calc - insert a row value in a cell and refer to that value in a formula?

I’d like to insert a row number in a cell and refer to that value in a formula cell reference. For instance, if I put the value “50” in cell A1, I’d like to write a formula using that value as a cell reference. =sum(D magic(1):D51) where the D1 via some method is evaluated to become D50 in the formula. Possible?

Why? Because I’m lazy and have a pile of formulas with a factor that changes over time. I want to change one cell instead of the pile.

Hello,

function `INDIRECT` is what you are looking for (see Help Online for INDIRECT)

`=SUM(INDIRECT("D" & A1 & ":D51"))`

(assuming cell `A1` contains your row value (e.g. `50` as in your detailed description)

If the answer is correct or helped you to solve your problem, please click the check mark ( ) next to the answer.

Works for group function “:” =SUM(INDIRECT(“F4:” & “D” & L2))
When I try to use other fuctions it gives a #REF! error: =SUM(INDIRECT(“F4+” & “D” & L2))
Help!