Christian Moe <m...@christianmoe.com> wrote:
> On 11/1/11 8:17 AM, henry atting wrote:
>
> > I was thinking of a column formula but have no clue if it's
> > possible and if so, how.
> >
> > In this short example the formula's length is no problem but for a
> > table with 12 rows or more it certainly is; -- and currently it's the
> > only way I can realize it.
> >
> > | | |
> > |---+---|
> > | 2 | |
> > | 6 | 4 |
> > | 7 | 5 |
> > #+TBLFM: @3$2=vmean(@2$1..@3$1::@4$2=vmean(@2$1..@4$1
>
>
> | | |
> |---+-----|
> | 2 | |
> | 6 | 4 |
> | 7 | 5 |
> | 3 | 4.5 |
> | 9 | 5.4 |
> #+TBLFM: @3$2..@>$2=vmean(@2$1..@0$1)
>
Another common way to deal with an exceptional cell is to use a field
formula for the exceptional cell and a column formula for the rest:
field formulas take precedence:
#+TBLFM: @2$2 = string("") :: $2 = vmean(@2$1..@0$2)
Nick
