Its not clear what exactly you're trying to do. If all of your data is
within the same workbook, then you don't need to reference the file name.

Try something like this:

=SUM('JAN06:DEC06'!B18)

This will sum all B18 cells in the sheets starting with JAN06 through DEC06.
Is that what you're trying to do?

HTH,
Elkar

"bookeater" wrote:


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