#1   Report Post  
Old September 30th 05, 08:24 PM
amartin-kelly
 
Posts: n/a
Default #NAME!#?

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

  #2   Report Post  
Old September 30th 05, 08:56 PM
gls858
 
Posts: n/a
Default

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

Make sure you used a colon and not a semi colon. Basically what Excel
is saying is that one of the names Week1 thru week4 is not recognized.
check the names make sure there aren't any spaces in any of the names.

gls858
  #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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017