One of the big problems with using that syntax.

Why don't you write a UDF, you can add error checking easily then (when
there aren't 3 for instance)?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Werner Rohrmoser" wrote in message
...
Hi,

I use a mane with a relative reference to sum 3 cells to the left or
in another case
the 3rd, 6th, 9th and 12th cell to the left.
The syntax for the name is "!A1:A3" when my pointer is in A4, formula
is "=SUM(Name). I wrote it without the sheetname, because I'd like to
use it on every sheet I have in the book.
Now, when I change values in the precedent cells nothing happens until
I force a complete recalculation,
it doesn't calculate automatically, also F9 doesn't force the formula
to calculate.
Any ideas or workarrounds, especially for "3rd, 6th, 9th and 12th"
case.

Excel XP SP3
Win XP SP1


Regards
Werner