Do you see letters in the column headings or numbers?

If you see numbers, try:
tools|options|general tab|uncheck R1C1 reference style.

Then retype the formula.



amartin-kelly wrote:

Hi I am putting in a formula =SUM(week1:week4!A8) because we named our pages
weeks. When I put in the formula it pops up saying something like #NAME!?#
telling me the name is unrecongnizable...any comments?

thanks

--

Dave Peterson