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
|