Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum IF function - linked to external worksheets
Excel 2000
I have a spreadsheet that utilizes the sumif function command from another external spreadsheet. If the other file is open, no problem, the function does its job. However, when the external file is not open and the dialog box asks me about updating links I get a value error in each cell. How do I make this work without opening the external file? Thanks in advance. Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum IF function - linked to external worksheets
Hi Dave
you may try using SUMPRODUCT instead as SUMIF does not work with closed workbooks. e.g. change a formula like =SUMIF('[Book2.xls]Tabelle1'!$A$1:$A$6,"condition",'[Book2.xls]Tabelle' 1!$B$1:$B$6) to =SUMPRODUCT(--('[Book2.xls]Tabelle1'!$A$1:$A$6="condition"),'[Book2.xls ]Tabelle'1!$B$1:$B$6) this will work even with closed workbooks -- Regards Frank Kabel Frankfurt, Germany Dave DJ wrote: Excel 2000 I have a spreadsheet that utilizes the sumif function command from another external spreadsheet. If the other file is open, no problem, the function does its job. However, when the external file is not open and the dialog box asks me about updating links I get a value error in each cell. How do I make this work without opening the external file? Thanks in advance. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External data link to Access - no linked tables? | Excel Discussion (Misc queries) | |||
automating external linked pivot table | Excel Discussion (Misc queries) | |||
How do linked worksheets exist with data on an external device | Excel Worksheet Functions | |||
Use checkboxes with linked external data? | Excel Discussion (Misc queries) | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |