emacs-orgmode
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]