INTERESTING....THANKS. NEVER HEARD OF SUMPRODUCT....I LOVE LEARNING NEW ****.

THANKS AGAIN! ;O)

"Dave Peterson" wrote:

There are some functions that don't work with closed workbooks. You found one
with =sumif().

But you could use a different formula to replace the =sumif() portion:

=sumproduct(--('yourpath\[GV LP Capital 2005.XLS]SUMMARY'!$G$1:$G$95=$f280),
'yourpath\[GV LP Capital 2005.XLS]SUMMARY'!$m$1:$m$95)



paige wrote:

This formula works only when i have the other referenced workbook open
simultaneously...when it is not open, i get the #VALUE! error....

Array Formula:
{=SUM(IF($F$5:$F$92=$F280,O$5:O$92))+SUMIF('O:\Gru ss Value
Fund\Capital\2005\[GV LP Capital 2005.XLS]SUMMARY'!$G$1:$G$95,$F280,'O:\Gruss
Value Fund\Capital\2005\[GV LP Capital 2005.XLS]SUMMARY'!M:M)}

--

Dave Peterson