From mboxrd@z Thu Jan  1 00:00:00 1970
From: Antony <lisp.linux@gmail.com>
Subject: spreadsheet sum a column
Date: Thu, 02 Dec 2010 02:29:56 -0800
Message-ID: <id7sfa$cou$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=53018 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PO9zH-000175-9A
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 09:18:41 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PO6Qd-0001T1-9W
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 05:30:20 -0500
Received: from lo.gmane.org ([80.91.229.12]:53595)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PO6Qc-0001Se-W4
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 05:30:19 -0500
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PO6QX-0008Pp-EV
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:30:13 +0100
Received: from 122.167.16.98 ([122.167.16.98])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 02 Dec 2010 11:30:13 +0100
Received: from lisp.linux by 122.167.16.98 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 02 Dec 2010 11:30:13 +0100
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: emacs-orgmode@gnu.org

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)

I am finding it hard to figure out how to do this.

-Antony