Someone just sent me a spreadsheet using this formula:
=SUM(A1:ABOVE).

It's great because if you delete the row above it (which was the bottom of
the SUM range), your formula is still valid.

Unfortunately, I can only use it in a new spreadsheet by copying it from the
one that was sent to me and even then I sometimes can't resolve the #VALUE
issues. I can't find anything about this syntax in the help menu or in the
discussion threads. Is it new? Any info would be helpful.
--
CG