Try using SUMPRODUCT

=SUMPRODUCT(--(rng1="value"),rng2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"chalky" wrote in
message ...

I have a simple sumif formula that for both the Range and Sum_Range link
to other another file. However, unless the linked to files are open i
get a #Value! error message. Unlike most linked formulas this doesnt
just hold the latest value.

Any ideas how i can get around this?


--
chalky
------------------------------------------------------------------------
chalky's Profile:
http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=514339