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(@[EMAIL PROTECTED]) > > 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 [EMAIL PROTECTED] PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3 _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
