Jonathan Leech-Pepin writes:
> I'm not sure as to the reason why it does so, but based on your
> example, the formula is referencing the specific cell itself, rather
> than the relative position of the cell. If you change your formula to
> use a relative reference, it will continue to work even
I'm not sure as to the reason why it does so, but based on your example,
the formula is referencing the specific cell itself, rather than the
relative position of the cell. If you change your formula to use a
relative reference, it will continue to work even when you add, remove and
move the rows.
Suppose I have this table:
| month | expenses | average |
|---+--+-|
| 1 | 20 | |
| 2 | 30 |25.0 |
| 3 | 40 |30.0 |
#+TBLFM: @3$3..@>$3=vmean(@2$2..@0$2);%.1f
Then I want to delete the second row and add a new one at the bottom.
If
