Rustom Mody <rustompm...@gmail.com> wrote: > When using orgmode for hacking on data in a table (org a la spreadsheet) I > have this situation > Say I am concentrating on column 2 and I want the bottom cell to be the sum > of the above cells > For a 7 row table with 8th row having the total I get > > #+TBLFM: @8$2=vsum(@1$2..@7$2) > > But now I have a problem: If say I add a row to the table then the next time > I recompute the formula > (s) the ninth row is not affected and the 8th row which is now data gets > overwritten with a > computation. > > So basically I want the @1 and @7 which are hardcoded above to be replaced by > something to the > effect: "everything above..." and the @8$2 should be something to the tune of > "bottom of $2" > > I guess this may not be a reasonable request -- but with org you never know > :-) so asking if there > is some way. > >
Of course it's reasonable - and of course, org implements it :-) #+TBLFM: $LR2=vsum(@1..@-1) In words: column 2 of the last row is the sum of all the rows (implicitly in column 2) from row 1 to the row above the last one. See section 3.5.1, "Tables>The spreadsheet>References" for more details. Nick _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode