>>> "ESF" == Eric S Fraga writes: > On Friday, 2 Jul 2021 at 11:23, Uwe Brauer wrote: >> No I only want to add the parts of column $1 and $2 that are between the >> two hlines > Okay; problem 1 is that org formulas are not really vector based: a > range on the left hand side says that each element in the range will be > assigned the outcome of the right hand side so the right hand side > should not be a vector. >> (I wanted to use hline @I and @II and not the explict row >> numbers, since this is more convenient. But it does to work with >> explicit row numbers > Yes, you cannot use @I etc. in the range definition for the target. > I can think of 2 options. First, you can use relative addressing, i.e.: > #+TBLFM: @<<$3..@>>$3=$1+$2 > where @<< means the second row and @>> the second last row. Thanks, that was helpful > Alternatively, you can introduce a new column at the start and use the > "Advanced Features" of the spreadsheet described in the info manual > section > (org) Advanced features > which will allow you to specify which rows should be evaluated (see the > * option). I will have a look thanks (I already thought about commenting out unwanted rows, but that looked ugly).