MIN across worksheets, with INDIRECT
 

I don't think I am omitting any quotes or &s, but this doesn't seem to work.
Am I not passing a valid range to the MIN function?

=MIN(INDIRECT("Rater1:Rater4!"&B3))

Is there another way to type it, or do I need a more creative function?

TIA

MIN across worksheets, with INDIRECT
 

Try
=MIN(Rater1:Rater4!&B3))

"andy62" wrote:

I don't think I am omitting any quotes or &s, but this doesn't seem to work.
Am I not passing a valid range to the MIN function?

=MIN(INDIRECT("Rater1:Rater4!"&B3))

Is there another way to type it, or do I need a more creative function?

TIA

MIN across worksheets, with INDIRECT
 

I don't think that works without using INDIRECT.

"Sheeloo" wrote:

Try
=MIN(Rater1:Rater4!&B3))

"andy62" wrote:

I don't think I am omitting any quotes or &s, but this doesn't seem to work.
Am I not passing a valid range to the MIN function?

=MIN(INDIRECT("Rater1:Rater4!"&B3))

Is there another way to type it, or do I need a more creative function?

TIA

MIN across worksheets, with INDIRECT
 

Cut and paste error... I tested with Sheet1,..

Try using
=MIN(Rater1:Rater4!B3)

assuming you want to find the MIN in Cell 3 across four sheets...

"andy62" wrote:

I don't think that works without using INDIRECT.

"Sheeloo" wrote:

Try
=MIN(Rater1:Rater4!&B3))

"andy62" wrote:

I don't think I am omitting any quotes or &s, but this doesn't seem to work.
Am I not passing a valid range to the MIN function?

=MIN(INDIRECT("Rater1:Rater4!"&B3))

Is there another way to type it, or do I need a more creative function?

TIA

MIN across worksheets, with INDIRECT
 

Why don't you try it?
--
David Biddulph

"andy62" wrote in message
...
I don't think that works without using INDIRECT.

"Sheeloo" wrote:

Try
=MIN(Rater1:Rater4!&B3))

"andy62" wrote:

I don't think I am omitting any quotes or &s, but this doesn't seem to
work.
Am I not passing a valid range to the MIN function?

=MIN(INDIRECT("Rater1:Rater4!"&B3))

Is there another way to type it, or do I need a more creative function?

TIA

MIN across worksheets, with INDIRECT
 

Sorry. I had removed the ampersand.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Why don't you try it?
--
David Biddulph

"andy62" wrote in message
...
I don't think that works without using INDIRECT.

"Sheeloo" wrote:

Try
=MIN(Rater1:Rater4!&B3))

"andy62" wrote:

I don't think I am omitting any quotes or &s, but this doesn't seem to
work.
Am I not passing a valid range to the MIN function?

=MIN(INDIRECT("Rater1:Rater4!"&B3))

Is there another way to type it, or do I need a more creative
function?

TIA