Hi there,

I'm trying to refer to the row number of a remote table, using the current
column number shifted by one.

Remote Table:
#+NAME: my-table
| Header1 | Header2 |
|---------+---------|
|   a     |    23  |
|   b     |    7    |
|   c     |    13  |
|   d     |    66  |
|   e     |    5    |
|---------+---------|
| Result  |  42 |


Table where remote value should be inserted:
...
#+TBLFM: @1$3..@1$7= remote(my-table,@$#$2)

My problem is, that this remote reference starts in row 3 (because of @$#),
however, I'd like to start in row 2 (that means @$#-1). However, this
relative reference does not seem to work here.

Any idea what command I can use here?

Thanks!

Best, Volker