Maybe you mean

=SUM(Sales_Prod1_06)

?
If not, which of the cells from the named range do you expect the formula to return?

If you refer to the type of "names" used in "Accept labels in formulas"; that feature is no longer present in Excel 2007

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Stephen Francis M" <Stephen Francis wrote in message
...
|I have created a name range for monthly sales (Jan thro to Dec) for each
| product. Example Name Sales_Prod1_06 which applies to cells N12:y12. On a
| summary worksheet I now want to reference this range and enter
| =Sales_Prod1_06. However I get Value! error if the name range is not entered
| in column N:y on the summary worksheet.
|
| I am sure I was able to do this without any probelm in the old version of
| excel ( I am now using 2007)
|
| Thanks for your help