Defining a range using a variable as the row #
Newbie question here.
Let's say we have a simple SUM formula:
Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell?
For example, rather than "15", something like
where "Row" could be sourced from the number value in a cell?
Thanks in advance for the help.
(this would be to SUM different rows as they are added through a form, and have the SUM of the most recently added row always appear in one particular cell)