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!
Please don’t use Answer function on this site, if you actually don’t answer a question but commenting another answer. Please use add a comment for that purpose…
Sorry, new kid on the block, don’t know the protocol.
Indirect seems to work 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))
Is there a way to add extra sauce?