Hi Uwe,
Uwe Brauer <o...@mat.ucm.es> writes: > Hi all > > Please look at > > | | Price | > |---+--------| > | / | 10.98 | > | | 11.90 | > | | 19.98 | > | | 13.79 | > | | 29.97 | > | | 18.98 | > | | 13.79 | > | | 11.90 | > | | 24.28 | > |---+--------| > | | 155.57 | > #+TBLFM: @11$2=vsum(@I$2..@II$2);f2 > > I would like to exclude the first value from the sum by adding some mark > in that row. ... > > Any idea how to exclude row values in a column? You could use 'vmask' to mask the values you don't want. Here is an example using vmask: | | Price | |----------------+--------| | 1 | 10.98 | | | 11.90 | | | 19.98 | | | 13.79 | | 1 | 29.97 | | | 18.98 | | | 13.79 | | | 11.90 | | | 24.28 | |----------------+--------| | | 155.57 | | Total unmarked | 114.62 | | Total marked | 40.95 | | Check all | OK | #+TBLFM: @11$2=vsum(@I$2..@II$2);f2 #+TBLFM: @12$2=vsum(vmask(map(<0 = #1>, @I$1..@II$1), @I$2..@II$2));f2NE #+TBLFM: @13$2=vsum(vmask(map(<1 = #1>, @I$1..@II$1), @I$2..@II$2));f2NE #+TBLFM: @14$2=string(if(@12$2+@13$2 = @11$2, "OK", "Oops!")) Bruno
