|
Linking Workbooks with formulas Sumif
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? |
Linking Workbooks with formulas Sumif
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? |
Linking Workbooks with formulas Sumif
Is there somewhere I can send the spreadsheets so someone could look at the
application? Thanks, Ken "Jim Thomlinson" wrote: 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? |
Linking Workbooks with formulas Sumif
I personally NEVER link workbooks so I would not be the guy to ask...
-- HTH... Jim Thomlinson "Damned88" wrote: Is there somewhere I can send the spreadsheets so someone could look at the application? Thanks, Ken "Jim Thomlinson" wrote: 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? |
| All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com