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)}