sum() using indiect()

G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum() using indirect() 3
Sumproduct when data column changes 1
make formula look at diff sheet 5
HowTo: detect a cell contains an ArrayFormula in vba? 1
Vlookup and return sheet name also 2
look to a cell for a reference to a sheet 2
Subtracting hours and minutes with negative times 2
Building closed workbook file path within an Index Function 6

Top