I am having a problem using the SUMIF formula. Everything works great when all the files I am using are open. As soon as I close the files that are in my formula, the cell changes to #VALUE
This is the formula:
=SUMIF('P:\folder\2012\[timesheet.xls]Sheet1!$A$3:$A$34,$A10000,'P:\folder\2012\[timesheet.xls]Sheet1!$J$3:$J$34)
Any ideas?
Bookmarks