Hi everyone,

Say you have 2 worksheet in a workbook: Sheet1, Sheet2

In Sheet2, you can read d12 value from Sheet1 using "=Sheet1!d12"

Now, say I have a range in Sheet1, how can I do thing such as (from Sheet2):

"=Sheet1!Max(d5:d12)" for example?

Reagrds,
Mike

"=Sheet1!Max(d5:d12)" for example
=max(Sheet1!d5:d12)
--
Don Guillett
SalesAid Software

"Michael" wrote in message
om...
Hi everyone,

Say you have 2 worksheet in a workbook: Sheet1, Sheet2

In Sheet2, you can read d12 value from Sheet1 using "=Sheet1!d12"

Now, say I have a range in Sheet1, how can I do thing such as (from
Sheet2):

"=Sheet1!Max(d5:d12)" for example?

Reagrds,
Mike

Mike
In a cell on Sheet2 enter.....

=MAX(Sheet1!D5:D12)

Gord Dibben Excel MVP

On 20 Jun 2004 11:12:15 -0700, (Michael) wrote:

Hi everyone,

Say you have 2 worksheet in a workbook: Sheet1, Sheet2

In Sheet2, you can read d12 value from Sheet1 using "=Sheet1!d12"

Now, say I have a range in Sheet1, how can I do thing such as (from Sheet2):

"=Sheet1!Max(d5:d12)" for example?

Reagrds,
Mike