Re: [Orgmode] Question on spreadsheet formula

2009-09-25 Thread Andreas Burtzlaff
Hi, you could rewrite the formula using vertical sums: |-+--+--+---| | No. |P |E | B | |-+--+--+---| | 1 | 5000 | 2000 | 3000 | | 2 | 7000 | 1000 | 9000 | | 3 | 5000 | 1000 | 13000 | #+TBLFM: $4=vsum(@-i$...@0$2)-vsum(@-i$...@0$3) HTH Andreas

[Orgmode] Question on spreadsheet formula

2009-09-25 Thread RC
Hi, On applying the column formula on the table shown below: |-+--+--+--| | No. |P |E | B| |-+--+--+--| | | | | 0| | 1 | 5000 | 2000 | | | 2 | 7000 | 1000 | | | 3 | 5000 | 1000 |