Hi
I have the following table | name | pos | rango | weight | |------+-----+-------+--------| | | 23 | 329 | 307 | | | 71 | 329 | 259 | | | 77 | 333 | 257 | | | 58 | 333 | 276 | | | 45 | 329 | 285 | | | 47 | 330 | 284 | | | 71 | 329 | 259 | | | 77 | 333 | 257 | | | 77 | 333 | 257 | | | 155 | 310 | 156 | | | 164 | 325 | 162 | | | 203 | 330 | 128 | #+TBLFM: $4=($3+1)-$2 I might be forced to add quite a bit of additional columns to that table making it difficult to read. So I thought to transpose the table as this, but how can I calculate the last row, using a calc operation. | Name | | | | | | | | | | | | | |--------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----| | pos | 23 | 71 | 77 | 58 | 45 | 47 | 71 | 77 | 77 | 155 | 164 | 203 | | rango | 329 | 329 | 333 | 333 | 329 | 330 | 329 | 333 | 333 | 310 | 325 | 330 | | weight | | | | | | | | | | | | | I tried #+TBLFM: @4$2..@4$13=(@3$2+1..@3$13+1)-(@2$2..@2$13);f1 but it did not work, of course I could try out to set a formula for each cell but frankly this would not be practical. Any suggestions? thanks Uwe Brauer -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against the Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of the Ukraine. I support the EU membership of the Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
