If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|