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)

(saved from a previous post)


Tami C wrote:

A link between two workbooks using the SUMIF function is not updating unless
you open the master workbook. Why isn't the s/s automatically updating?

--

Dave Peterson