* Karl Voit <devn...@karl-voit.at> wrote: > > I would like to refer to the second to last row of a table. > > The following example should demonstrate my issue. What I expect is > that the following formula is filling @2..@5 with "1" and in the > last row, there is the sum of all "1".
I am happy to have found the answer to my question on my own: @>> is the second to last row. @>>> the one before. Same holds for columns: $>> is the second to last column. The solution for my example is: | Values | |--------| | 1 | | 1 | | 1 | |--------| | 1 | | 1 | | 1 | |--------| | 6 | #+TBLFM: @2$1..@>>$1=1 :: @>$1=vsum(@2$1..@>>$1) -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: > get Memacs from https://github.com/novoid/Memacs < https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github