emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]