[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Table summation
From: |
Russell Adams |
Subject: |
Re: [Orgmode] Table summation |
Date: |
Tue, 1 Apr 2008 11:19:35 -0500 |
User-agent: |
Mutt/1.5.13 (2006-08-11) |
On Tue, Apr 01, 2008 at 11:05:01AM -0500, Russell Adams wrote:
> 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(@address@hidden)
>
> 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.
In reply to myself, perhaps a way to refer to last cell would work.
| 15 |
|--------|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
#+TBLFM: @1$1=vsum($I..$LAST)
That way using tab on the value "5" would add a new line and not break
the formula reference.
Thanks.
------------------------------------------------------------------
Russell Adams address@hidden
PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/
Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3