MIN/MAX Multiple worksheets
 

How can I get min/max of a single cell reference from up to 50 worksheets in
a single workbook?

MIN/MAX Multiple worksheets
 

=min(Sheet2!A1,Sheet3!A1,......................... .........................................)

Dave R wrote:

How can I get min/max of a single cell reference from up to 50 worksheets in
a single workbook?

MIN/MAX Multiple worksheets
 

=MIN('Title of sheet'!cell range,repeat for all sheets)

"Dave R" wrote:

How can I get min/max of a single cell reference from up to 50 worksheets in
a single workbook?

MIN/MAX Multiple worksheets
 

Try this:

=MIN(Sheet1:Sheet50!A1)

=MAX(Sheet1:Sheet50!A1)

--
Biff
Microsoft Excel MVP


"Dave R" wrote in message
...
How can I get min/max of a single cell reference from up to 50 worksheets
in
a single workbook?

MIN/MAX Multiple worksheets
 

I have the same problem i tried these formulas but i geat a ref error, need
to know how to do this all my sheets reads 0 for the cell im using until data
is entered so i have tried =min('Week 1:Week 52'!,w265 & get a ref error also
tried 0 with this & still the same

"kpt" wrote:

=MIN('Title of sheet'!cell range,repeat for all sheets)

"Dave R" wrote:

How can I get min/max of a single cell reference from up to 50 worksheets in
a single workbook?

MIN/MAX Multiple worksheets
 

You could use 2 dummy sheets called something like First and Last or Start
and End then add all the future sheets in-between those 2 sheets and use a
formula like


=MIN(Start:End!W265)




--


Regards,


Peo Sjoblom


"Mike" wrote in message
...
I have the same problem i tried these formulas but i geat a ref error, need
to know how to do this all my sheets reads 0 for the cell im using until
data
is entered so i have tried =min('Week 1:Week 52'!,w265 & get a ref error
also
tried 0 with this & still the same

"kpt" wrote:

=MIN('Title of sheet'!cell range,repeat for all sheets)

"Dave R" wrote:

How can I get min/max of a single cell reference from up to 50
worksheets in
a single workbook?