Folderol wrote:
Still makes a complete mess of it :(
The formula I have in column F(n) is:
=F(n-1)-C(n)-D(n)+E(n)
This produces a running total. Adding or removing a line screws up the
rest. I have to do a 'fill down' on the F column (hmmm, appropriate)
covering the cells either side of any insertion or deletion.
Ideally I would like to be able to just copy in (or out) a block of
lines from another part of the spreadsheet.
Yes, it tries to keep the referenced *single values* and gives an error
if the values are no longer availlable.
You may try:
F1: =-$C1-$D1+$E1 (or simply 0, depends on the required start-value)
F2: =SUM($F$1:$F1)-$C2-$D2+$E2 (notice the mixed reference $F$1:$F1)
drag down F2
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
