I'm trying to perform a SUMIF function in one workbook (destination) using
some cells in another workbook (source). It only works if I have the source
workbook open. If it's not open, I get a #VALUE! error in the SUMIF cell of
the destination workbook. Any suggestions?