Ps. I'd open that other workbook and build the formula by pointing and
clicking. Excel will add the path when you close the workbook.

And you won't be able to use the whole column in that formula.

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