Formula Links to seperate workbooks

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" <Brokovich.2cdpie_1155305111.3109@excelforum-nospam.com> wrote
in message news:Brokovich.2cdpie_1155305111.3109@excelforum-nospam.com...

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\Management
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

Thankyou both very much for your help on this one. To be honest I found the easiest way around it was to place the sumif function on the source workbook and then link to that result.

This has worked perfectly so I will stick with that as it is a lot simpler and means I don't have to move any of the source workbook around.

Thanks again though!

Thanks for the feed-back.
--

Regards,

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

"Brokovich" <Brokovich.2cdrtq_1155308108.6643@excelforum-nospam.com> wrote
in message news:Brokovich.2cdrtq_1155308108.6643@excelforum-nospam.com...

Thankyou both very much for your help on this one. To be honest I found
the easiest way around it was to place the sumif function on the source
workbook and then link to that result.

This has worked perfectly so I will stick with that as it is a lot
simpler and means I don't have to move any of the source workbook
around.

Thanks again though!


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