If it's not a named range it sounds like it may a a UDF (User Defined
Function). When you open the file do you get the 'Enable Macro's' prompt? If
so try hitting Alt and F11 to open the VB editor and open all the folders
on the left to see if there's any code in them. If there is copy and paste
it into a post and someone will probably be able to explain.
Regards,
Alan.
"CEG" wrote in message
...
After more experimenting, it does act somewhat like a named range. For
example, row 30 totals rows 2-29 in columns B:G using the formula
=SUM(B2:ABOVE), etc. and gives accurate totals.

However, if you select cell D10 and create the range name "above", you get
these values (formula doesn't change, just the results):

B30 = B2:D10
C30 = C2:D10
D30 = D2:D10
E30 = D2:E10
F30 = D2:F10
G30 = D2:G10

Then, if you delete the range name "above", all the sums go to #VALUE!
error.
--
CG


"Dave F" wrote:

It sounds like ABOVE is a named range?

Check the named range list in the drop down box to the left of the
formula
bar. Do you see a named range called ABOVE?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CEG" wrote:

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