Sumif Error when Referenced Wkbk not open

M

Maverick_TG

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
 
Top