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