[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] Re: spreadsheet sum a column
From: |
Detlef Steuer |
Subject: |
[Orgmode] Re: spreadsheet sum a column |
Date: |
Thu, 2 Dec 2010 17:59:59 +0100 |
On Thu, 02 Dec 2010 02:29:56 -0800
Antony <address@hidden> wrote:
> Hi
>
> I have a simple need (from a requirement description point).
>
> 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)
| foo | amount |
|-----------+--------|
| | |
| hello | 100 |
| again | 200 |
| once more | 300 |
| qqq | 100 |
| | 700 |
#+TBLFM: @7$2=vsum(@address@hidden)
You find information about that in the manual under "spreadsheet".
Hth
Detlef
>
> I am finding it hard to figure out how to do this.
>
> -Antony
>
>
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> address@hidden
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>