sum() using indirect()
 

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??

sum() using indirect()
 

Invalid syntax

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

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


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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??

sum() using indirect()
 

Thanks Bob,
That did it, though I'm not sure why the full path wouldn't work.



Bob Phillips wrote:
Invalid syntax

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

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


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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??