Sumif does not work well with closed workbooks. Take a look at sumproduct...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Damned88" wrote:

The linked information only updates if the other workbooks are opened.
I have the correct path, however, the workbook only inputs a value if the
workbook with the data is open.

This if other workbook(Data) is not open=Value

=SUMIF('G:\COREFCO EXPANSION\Phase 2\(900-00-12-000) Construction\Cost
Control\JCRs\Budgets\[Expansion
Estimate.xls]Master'!$M$2:$M$10000,TEXT($B$7,"0")&"-"&TEXT($H$10,"00")&"-"&TEXT($A16,"00")&"-"&TEXT($A$2,"00"),'G:\COREFCO
EXPANSION\Phase 2\(900-00-12-000) Construction\Cost
Control\JCRs\Budgets\[Expansion Estimate.xls]Master'!$H$2:$H$10000)

This if opened=Correct Updated value

=SUMIF('[Expansion
Estimate.xls]Master'!$M$2:$M$10000,TEXT($B$7,"0")&"-"&TEXT($H$10,"00")&"-"&TEXT($A16,"00")&"-"&TEXT($A$2,"00"),'[Expansion
Estimate.xls]Master'!$H$2:$H$10000)

How can I make this work without having to open the database workbook?