Linking in the same workbook

[bookeater]

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

 

[Guest]

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('JAN06EC06'!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]

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