Hi!

Make the 2nd reference just the cell address:

A1 = [TestBook.xls]Sheet1!B1
A2 = B10

=SUM(INDIRECT(A1&":"&A2))

Or, put the path in one cell and the cell references in other cells:

A1 = [TestBook.xls]Sheet1!
A2 = B1
A3 = B10

=SUM(INDIRECT(A1&A2&":"&A3))

Just note that the other file HAS to be open for this to work. If it's not
open you'll get a #REF! error.

Biff

"Grymjack" wrote in message
...
Can anyone post a formula that successfully uses
SUM(INDIRECT("concatenated cell range")) where the path isn't local to the
sheet it is on?

ex:

A1 = [TestBook.xls]Sheet1!B1
A2 = [TestBook.xls]Sheet1!B10

=SUM(INDIRECT(A1&":"&A2))

....can you get that one to work??