#NAME!#?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amartin-kelly - 30 Sep 2005 20:24 GMT

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

Reply to this Message

gls858 - 30 Sep 2005 20:56 GMT

> 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

Reply to this Message

Dave Peterson - 30 Sep 2005 23:45 GMT

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.

Signature

Dave Peterson

Reply to this Message