[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] spreadsheet sum a column
From: |
Michael Brand |
Subject: |
Re: [Orgmode] spreadsheet sum a column |
Date: |
Thu, 2 Dec 2010 17:13:56 +0100 |
On Thu, Dec 2, 2010 at 11:29, Antony <address@hidden> wrote:
> I have table like
>
> | foo | amount |
> |-----------+--------|
> | | <5> |
> | hello | 100 |
> | again | 200 |
> | once more | 300 |
> | | |
> | | |
>
> I need to be able sum those numbers and say 600 somewhere (I am ok if it
> does in the same table or outside of it)
>
> When I add a new row, say
>
> | foo | amount |
> |-----------+--------|
> | | <5> |
> | hello | 100 |
> | again | 200 |
> | once more | 300 |
> | qqq | 100 |
> | | |
>
> Now I need to be able to change the 600 to 700 (by pressing C-c C-c
> somewhere)
>
> I am finding it hard to figure out how to do this.
Press C-c C-c on the TBLFM line after every change:
| foo | amount |
|-----------+--------|
| hello | 100 |
| again | 200 |
| once more | 300 |
|-----------+--------|
| | 600 |
#+TBLFM: $LR2 = vsum(@address@hidden)
I don't think `<5>' is of any use in this case.
Michael