| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
