Thread: #NAME!#?
View Single Post
  #3   Report Post  
Old September 30th 05, 11:45 PM
Dave Peterson
 
Posts: n/a
Default

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