software

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: www.excelforum.com/member.php...oamp;userid=23758
View this thread: www.excelforum.com/showthread...hreadid=514339Try using SUMPRODUCT

=SUMPRODUCT(--(rng1=quot;valuequot;),rng2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;chalkyquot; gt; wrote in
message ...
gt;
gt; I have a simple sumif formula that for both the Range and Sum_Range link
gt; to other another file. However, unless the linked to files are open i
gt; get a #Value! error message. Unlike most linked formulas this doesnt
gt; just hold the latest value.
gt;
gt; Any ideas how i can get around this?
gt;
gt;
gt; --
gt; chalky
gt; ------------------------------------------------------------------------
gt; chalky's Profile:
www.excelforum.com/member.php...oamp;userid=23758
gt; View this thread: www.excelforum.com/showthread...hreadid=514339
gt;