Not sure how to make sumif work, but Sumproduct may be an alternative.

As an example, this formula will return the number of times "jeff" appears
in range A1:A4 of Book1.

=SUMPRODUCT(--('H:\Blakley\Excel\[Book1.xls]Sheet1'!A1:A4="jeff"))

"Scorpvin" wrote:


My sumif formula only works if I have the source document open. If I
open the file with the sumif first and update links it returns #VALUE!
When I open the source document it works automatically. I know the
reason is because I'm referencing another workbook. Is there something
I need to add to the formula or is there an option in excel I need to
adjust?


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=471902