View Single Post
  #1   Report Post  
Barb Reinhardt
 
Posts: n/a
Default 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