Use SUMPRODUCT.

--
Biff
Microsoft Excel MVP


"GB" wrote in message
...
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?