Hello, Karl Voit <devn...@karl-voit.at> writes:
> | | 20 | 21 | 22 | 23 | 24 | > | | :=vsum(@3..@>) | | | | | > |-----+----------------+----+----+----+----| > | | | | | | | > |-----+----------------+----+----+----+----| > | | 1 | 1 | | | 1 | > | Foo | 2 | | | | | > | Bar | | | 2 | 3 | | > |-----+----------------+----+----+----+----| > | | | | | | | > |-----+----------------+----+----+----+----| > | Bar | | 4 | 1 | | | > | Foo | | | 2 | | 2 | > | Bar | | | 3 | 5 | | > | Foo | | 1 | | | 5 | > |-----+----------------+----+----+----+----| > > I got: Spreadsheet error: invalid reference "vsum(@3..@>)" when I > try to apply the formula. I cannot reproduce the problem. > > Also tried and also failed with same message: > vsum(@3$2..@>$2) > vsum(@I$2..@>$2) > vsum(@I+1$2..@>$2) Same here. > Bonus question: when I want to apply the formula to @2$2 and *all* > table elements rights of it until the last column, is there a way to > define this without having five separate formula? @2$2..@2$>=vsum(@3..@>) Regards, -- Nicolas Goaziou
