Yes you can. Show us what you have tried.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"quailc" wrote in
message ...

I would be grateful if someone could offer their advice on how to solve
a problem I am having with XL.

Is it possible to perform the SUMPRODUCT function on a data range that
is in a seperate workbook?

I have tried selecting the range from another workbook but it comes
back with #value result.

How do I link the 2 workbooks together for this to work correctly?


--
quailc
------------------------------------------------------------------------
quailc's Profile:
http://www.excelforum.com/member.php...o&userid=34442
View this thread: http://www.excelforum.com/showthread...hreadid=542080