The fact is that some functions *do not* work on *closed* WBs.
Sumif, Countif, Index are some of these.

A work-around for your formula is to use an *array* formula combination of
Sum and If:

=SUM(IF('K:\Financial_practitioners\Management
Info\Expenses\[PeterAylward0607.xls]Jun'!$C$6:$C$29="AF",'K:\Financial_pract
itioners\Management Info\Expenses\[Peter Aylward 0607.xls]Jun'!$S$6:$S$29))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Brokovich" wrote
in message ...

Hi Dave

Thanks for that info. I tried it but these options were already ticked.


What I meant by cells without formulas was as below:

Cells which contain the following
='[MI Master Spreadsheet 0607.xls]Adam Fearn'!$H$74
are updating without problem, whereas the cells containing the below
=SUMIF('K:\Financial_practitioners\Management Info\Expenses\[Peter
Aylward
0607.xls]Jun'!$C$6:$C$29,"AF",'K:\Financial_practitioners\M anagement
Info\Expenses\[Peter Aylward 0607.xls]Jun'!$S$6:$S$29)
are not.

I thought this could be due to the fact that the referenced worksheets
are within a formula...?

Can you help any further?

Thanks again.


--
Brokovich
------------------------------------------------------------------------
Brokovich's Profile:
http://www.excelforum.com/member.php...o&userid=37098
View this thread: http://www.excelforum.com/showthread...hreadid=570724