sum() using indirect()

[Grymjack]

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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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??

[Grymjack]

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" <[email protected]> wrote in message
> news:[email protected]...
>> 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??
>
>