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