Thanks for your time and help, Frank.
Here's the formula:
=SUM(INDEX('S:\_Finance_and_Administration_Corpora te\Forecast - New 2004
Models\Models\[Vancouver.xls]CombinedPL'!$B$6:$O$500,MATCH(B$9,'S:\_Finance_and _Administration_Corporate\Forecast
- New 2004
Models\Models\[Vancouver.xls]CombinedPL'!$B$6:$B$500,0),MATCH("JAN",'S:\_Financ e_and_Administration_Corporate\Forecast
- New 2004
Models\Models\[Vancouver.xls]CombinedPL'!$B$6:$O$6,0),1):INDEX('S:\_Finance_and _Administration_Corporate\Forecast
- New 2004
Models\Models\[Vancouver.xls]CombinedPL'!$B$6:$O$500,MATCH(B$9,'S:\_Finance_and _Administration_Corporate\Forecast
- New 2004
Models\Models\[Vancouver.xls]CombinedPL'!$B$6:$B$500,0),MATCH($B$5,'S:\_Finance _and_Administration_Corporate\Forecast
- New 2004 Models\Models\[Vancouver.xls]CombinedPL'!$B$6:$O$6,0),1))
Stephen

"Frank Kabel" wrote:

Hi Stephen
it would help if you could post the complete formula. There's probably
a different way

--
Regards
Frank Kabel
Frankfurt, Germany

"Stephen POWELL" schrieb im
Newsbeitrag ...
Frank:
Then you're saying it is not possible to do what I want using the
structure
SUM(INDEX(...):INDEX(...)). How unjust!!!
The alternative would be hiding twelve columns (one for each month)
in the
destination workbook each of which picks up only one cell in the
source
workbook and my INDEX function would operate in the thirteenth column
to SUM
the correct number of columns depending on which months I want.
Would working with ARRAY help here?
Thanks,
Stephen

"Frank Kabel" wrote:

Hi
this is just the usage of your syntax. Your kind of cell reference
is
just not correct for closed workbooks

--
Regards
Frank Kabel
Frankfurt, Germany

"Stephen POWELL" schrieb
im
Newsbeitrag
...
Thanks, Frank. I forgot to mention that when I open all the
source
workbooks
the linking formulas in the destination workbook produce the
correct
results.
You may be on to something so I went back and re-performed the
EVALUATE
FORMULA and the way I first presented it is accurate. I'm still
baffled.

"Frank Kabel" wrote:

Hi
this is not a valid reference you have created. The valid
reference
would look like:
SUM('path\[filename]\worksheet'!$C$27:$J$27)

You may post the complete formula

--
Regards
Frank Kabel
Frankfurt, Germany

"Stephen POWELL"
schrieb
im
Newsbeitrag
...
1. Working in a network environment.
2. My dependent workbook in one subdirectory links to several
source
workbooks all in one other directory (this has never been a
problem
before).
3. All such linking formulas show "#REF!". But everything
worked
fine last
week when I created the dependent workbook with its links.
4. Formula in dependent workbook is:
SUM(INDEX(...BLAH...BLAH):INDEX(...BLAH...BLAH))
5. I have used TOOLS/FORMULA AUDITING/EVALUATE FORMULA to
confirm
that the
INDEX arguments within the SUM formula each evaluate to the
proper
cells in
the source workbooks. In other words, I proceeded through
EVALUATE
FORMULA
until I got



SUM('path\[filename]\worksheet'!$C$27:'path\[filename]\worksheet'!$J$27
) and
the next EVALUATE step produced the "REF!".

Any suggestions?
Many thanks,
Stephen Powell