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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculating the maximum value in a range of cells in a closed work (https://www.excelbanter.com/excel-worksheet-functions/49807-calculating-maximum-value-range-cells-closed-work.html)

Barb Reinhardt

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

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

Barb Reinhardt

I figured out part of my problem. If I have another one, I'll come back and
ask.

"Barb Reinhardt" wrote:

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

All times are GMT +1. The time now is 10:57 AM.