I'm trying to create a generalised expense claim form for a group of
people. Each row refers to a particular expense and the user of the form
(the claimant) adds rows as needed, so the actual number of rows is
unknown at the time of creating the form.
What I would like to be able to do is, for example, insert the SUM
function in a particular column to sum all the cells in the column above
it (some may be empty) up to a particular row.
For example, suppose the SUM function is in column C then I would like
to write something like: SUM(C9:C(*-1)) where "*" refers to the row the
SUM function is in after the user has added an unknown number of rows
after row 9. Then, if there were 3 expenses (rows 9, 10 and 11) the
function would turn out to be SUM(C9:C11). I want the function to change
itself.
Is this possible? I can't really believe nobody has needed to do this
sort of thing before.