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.