| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif Error when Referenced Wkbk not open
In Excel Wkbk A, I have several sumif formulas pulling from Excel Wkbk
B. For some reason, the formula results in an error whenever the referenced Wkbk B is not open. Once opened, the error is resolved. Any suggestions to have Wkbk B closed without the error values? I am operating in MS Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif Error when Referenced Wkbk not open
Use SUMPRODUCT instead of SUMIF.
-- Biff Microsoft Excel MVP "Maverick_TG" wrote in message ... In Excel Wkbk A, I have several sumif formulas pulling from Excel Wkbk B. For some reason, the formula results in an error whenever the referenced Wkbk B is not open. Once opened, the error is resolved. Any suggestions to have Wkbk B closed without the error values? I am operating in MS Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL:Can't open any file without error saying it's ALREADY open??? | Excel Worksheet Functions | |||
| Can't Alt Tab from wkbk to wkbk Help! | Excel Discussion (Misc queries) | |||
| Links error if referenced file not opened | Excel Worksheet Functions | |||
| double click mouse, move to referenced wkbk/cell | Setting up and Configuration of Excel | |||
| is it always necessary to open workbooks referenced in a formula | Excel Discussion (Misc queries) | |||
Linear Mode
