Is there a way to do something like Sheet1::Table1::SUM(A1:AΩ), where Ω returns the last row number on Sheet1? This would enable leaving Sheet1 with values only, no formulas.


Turns out this is dead simple: SUM(Sheet1::Table1::A), or SUM(Sheet1::Table1::ColumnName).

|improve this answer|||||

You must log in to answer this question.

Not the answer you're looking for?Browse other questions tagged .