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

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

Thanks, its almost there.
I'm trying to keep a running total, for instance
April 5555
year to dte total 5666 (previous + april)
Your formula works on current month previous months have #name error


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