Calculating the maximum value in a range of cells in a closed work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm attempting to calculate the maximum value in a range of cells in 60-80
closed workbooks.

I have this in cell A1
'Y:\Folder1\Folder2[doc.xls]Title'!$A$1:$A$20
I have this in cell A2
=MAX(INDIRECT.EXT(A1))

What am I missing?

Thanks in advance,

Barb Reinhardt
 
I figured out part of my problem. If I have another one, I'll come back and
ask.
 
You must log in or register to reply here.

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

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Calculating a Formula Subject to a Maximum and Minimum Value 2
Counting cells in a selectable date range 0
Referencing a named range based upon Range name entry in cell 14
How to I set a limit on the value returned by a cell 3
Return a given value if the value of a cell is in a given range 2
Max of a defined function 4
Maximum Number of Blank Cells between Non Blank Cells in a Range 5

Back
Top