Sorry to bother this way Bob, but your site seems to be offline

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bob Phillips" wrote in message ...
| 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
|
|