sumif will not work with closed workbooks,
a workaround is to use a worksheet with diect references to each significant
cell in the closed workbooks and do your sumif on this worksheet.
You can protect the sheet so that others can't see it easily if you don't
wnat them to see the data.

"foofightin" wrote:

My colleague is having trouble linking to another workbook, which he wants to
remain closed. The link looks like this:

=-SUMIF('G:\Master Appraisals & Cashflows\BLEL proformas\[BLEL - Northampton
J16 M1.xls]Array List'!$B$3:$B$26,"=01/08/2007",'G:\Master Appraisals &
Cashflows\BLEL proformas\[BLEL - Northampton J16 M1.xls]Array
List'!$C$3:$C$26)

Trouble is, we have around 16 workbooks we're linking in this way, so
amalgamating is not an option.

Can this work with workbooks when they remain closed?
Any help appreciated. Thanks, Greg