Hi,
Newbie question here.
Let's say we have a simple SUM formula:
=SUM([Column1]15:[Column4]15)
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
=SUM([Column1]Row:[Column4]Row)
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)