what is wrong with this formula
=sum b18 ['rent log.xls'] JAN06 !B18

THE WORKBOOK IS 12 MONTHS WORTH OF DATA
THE FIELD WAS CREATED FOR A YEAR TO DATE TOTAL
THANK YOU


--
bookeater
------------------------------------------------------------------------
bookeater's Profile: http://www.excelforum.com/member.php...o&userid=35503
View this thread: http://www.excelforum.com/showthread...hreadid=552715