Well, I'm not very well versed in excel at all. I did a little
searching in the help file in excel and its the only thing I could come
up with to give me what I wanted. I tried your formula and went in and
entered some data on week 1, but the total didn't transfer to the weekly
totals sheet. any ideas?


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546580