[Tfug] oo.org spreadsheet formula question.

[Josh Miller]

Another way to do this:

D1:	=SUM($C$1:C1)

Copying this formula down column D (or copying and pasting) will update 
the second cell reference relative to the current row and the $s in the 
first cell reference will keep it static.

The other ways mentioned will also work, of course

- Josh

Glen Pfeiffer wrote:
> --- 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
> _______________________________________________
> tfug mailing list
> tfug at tfug.org
> http://www.tfug.org/mailman/listinfo/tfug
>