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.
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.
Sign up to join this community