From mboxrd@z Thu Jan  1 00:00:00 1970
From: Detlef Steuer <detlef.steuer@gmx.de>
Subject: Re: spreadsheet sum a column
Date: Thu, 2 Dec 2010 17:59:59 +0100
Message-ID: <20101202175959.31374096@rechenknecht.site>
References: <id7sfa$cou$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=45741 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1POCTU-0003oK-76
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:58:19 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1POCTF-0007y0-9s
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:57:40 -0500
Received: from lo.gmane.org ([80.91.229.12]:43128)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1POCTF-0007xT-3w
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 11:57:25 -0500
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1POCTB-0004qw-N2
	for emacs-orgmode@gnu.org; Thu, 02 Dec 2010 17:57:21 +0100
Received: from e176094252.adsl.alicedsl.de ([85.176.94.252])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 02 Dec 2010 17:57:21 +0100
Received: from detlef.steuer by e176094252.adsl.alicedsl.de with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 02 Dec 2010 17:57:21 +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

On Thu, 02 Dec 2010 02:29:56 -0800
Antony <lisp.linux@gmail.com> 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(@3..@-1)

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.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>