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

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