Re: Table summation

[Russell Adams <RLAdams@AdamsInfoServ.Com>]

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(@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.

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                            RLAdams@AdamsInfoServ.com

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

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