SUMIF Link

C

chalky

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?
 
B

Bob Phillips

Try using SUMPRODUCT

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top