| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative to SUMif when linking to closed workbooks | Excel Discussion (Misc queries) | |||
| SUMIF linking to closed workbooks. | Excel Discussion (Misc queries) | |||
| Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
| My sumif formulas containin links to other workbooks do not calcul | Excel Worksheet Functions | |||
| linking two workbooks together | Excel Discussion (Misc queries) | |||
Linear Mode
