[Tfug] oo.org spreadsheet formula question.

[Glen Pfeiffer]

--- Quag7 <coldfront at frostwarning.com> wrote:
> I have a column (C) like this:
> 
> C
> --
> (Row 1) 100.00
> (Row 2) 100.00
> (Row 3) 100.00
> (Row 4) 150.00
> (Row 5) 100.00
> 
> I want column D to be a running total from the first
> value just up to
> that specific row, so that  D2 would read $200, D3 would
> read $300, D4
> would read $450.00 and so on.

There may be a feature that allows you to do so, but if not
this is one technique.

D1:    =C1
D2:    =SUM(C2:D1)

Now if you copy and paste the the formula from D2 down
through the other D fields, it should automatically update
the number in the formula accordingly. So the end result is
each D field has a different formula which sums the
preceding D field and the corresponding C field.

Also, not sure if you know this, but when a cell is
highlighted, there is a small black square at the bottom
right of the cell. If you put your mouse cursor over that
block it will turn to a "cross-hair" which looks like a
plus sign - sort of. Click and drag down - that will copy
the contents of the first cell down to all the highlighted
cells.

Hope it helps,
Glen