Linking Workbooks with formulas Sumif

[Damned88]

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?

 

[Jim Thomlinson]

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

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

 

[Damned88]

Is there somewhere I can send the spreadsheets so someone could look at the
application?

Thanks,

Ken

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

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

Jim Thomlinson

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?

 

[Jim Thomlinson]

I personally NEVER link workbooks so I would not be the guy to ask...
--
HTH...

Jim Thomlinson

Is there somewhere I can send the spreadsheets so someone could look at the
application?

Thanks,

Ken

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

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

Jim Thomlinson

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?