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.
Sum an entire column in Numbers from a different sheet
iworknumbers
iworknumbers
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.
Best Answer
Turns out this is dead simple:
SUM(Sheet1::Table1::A), orSUM(Sheet1::Table1::ColumnName).