From mboxrd@z Thu Jan  1 00:00:00 1970
From: Russell Adams <RLAdams@AdamsInfoServ.Com>
Subject: Table summation
Date: Tue, 1 Apr 2008 11:05:01 -0500
Message-ID: <20080401160501.GE2015@odin.demosthenes.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1Jgiz4-00015Y-3x
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:05:14 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Jgiz2-00014x-Mi
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:05:13 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Jgiz2-00014u-Hj
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:05:12 -0400
Received: from squirtle.drak.net ([72.52.144.201])
	by monty-python.gnu.org with esmtps
	(TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60)
	(envelope-from <rladams@adamsinfoserv.com>) id 1Jgiz1-0007HV-FI
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 12:05:12 -0400
Received: from [206.180.154.177] (helo=localhost)
	by squirtle.drak.net with esmtpa (Exim 4.68)
	(envelope-from <rladams@adamsinfoserv.com>) id 1Jgiyn-000333-9q
	for emacs-orgmode@gnu.org; Tue, 01 Apr 2008 11:04:57 -0500
Content-Disposition: inline
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/pipermail/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: Org Mode List <emacs-orgmode@gnu.org>

Speaking of tables today, I thought I'd post a question that I haven't
found a simple answer for.

How do you sum a table reliably? (ie: tolerant of editing)

This table requires the use of org-table-insert-row (etc...) in order
to keep the formula correct.

| Header |
|--------|
|      1 |
|      2 |
|      3 |
|      4 |
|      5 |
|--------|
|     15 |
#+TBLFM: @7$1=vsum(@I..@II)

How can I do something like this, where the last cell is automatically
the sum of the column, and not an absolute reference that must be maintained?

|      1 |
|      2 |
|      3 |
|      4 |
|      5 |
|--------|
|     15 |
#+TBLFM: LAST=vsum($0..$0)

Thanks.


------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3