From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: spreadsheet sum a column
Date: Thu, 2 Dec 2010 17:13:56 +0100
Message-ID: <AANLkTiko=hCj1AAryCGYFA5Wi_CVy4wjP9_2t3T4Ny+a@mail.gmail.com>
References: <id7sfa$cou$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=38928 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1POBnF-0003Vk-RX
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:14:02 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1POBnE-0008FZ-NX
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:14:01 -0500
Received: from mail-yw0-f41.google.com ([209.85.213.41]:64566)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1POBnE-0008FV-Kx
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:14:00 -0500
Received: by ywj3 with SMTP id 3so1593683ywj.0
	for <emacs-orgmode@gnu.org>; Thu, 02 Dec 2010 08:13:56 -0800 (PST)
In-Reply-To: <id7sfa$cou$1@dough.gmane.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Antony <lisp.linux@gmail.com>
Cc: emacs-orgmode@gnu.org

On Thu, Dec 2, 2010 at 11:29, Antony <lisp.linux@gmail.com> wrote:
> I have table like
>
> | foo =A0 =A0 =A0 | amount |
> |-----------+--------|
> | =A0 =A0 =A0 =A0 =A0 | =A0 =A0<5> |
> | hello =A0 =A0 | =A0 =A0100 |
> | again =A0 =A0 | =A0 =A0200 |
> | once more | =A0 =A0300 |
> | =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 =A0|
> | =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 =A0|
>
> 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 =A0 =A0 =A0 | amount |
> |-----------+--------|
> | =A0 =A0 =A0 =A0 =A0 | =A0 =A0<5> |
> | hello =A0 =A0 | =A0 =A0100 |
> | again =A0 =A0 | =A0 =A0200 |
> | once more | =A0 =A0300 |
> | qqq =A0 =A0 =A0 | =A0 =A0100 |
> | =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 =A0|
>
> 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 =3D vsum(@I$2..@-1$2)

I don't think `<5>' is of any use in this case.

Michael