Max problem

[BNT1 via OfficeKB.com]

Hi

In a range of cells i have the formula,
=IF(INDIRECT("'"&(B1)&"'!c5")="",NA(),INDIRECT("'"&(B1)&"'!c5")), this
returns N/a when c5 is empty.
I have an average of the cells in the range, at the end of the row with the
following formula
=AVERAGE(IF(ISNUMBER(B3:M3),B3:M3))
All this is working fine, as the N/A is then conditional format in white
But when I enter =max(B3:M3), in another cell, I get N/A, presumably, because
some cells contain the forced N/A. I have tried =max(isnumber(B3:M3), but
still no joy.

Any pointers?

Thanks in advance

Regards

 

[Peo Sjoblom]

Try

=MAX(IF(ISNUMBER(B3:M3),B3:M3))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

 

[BNT1 via OfficeKB.com]

Thanks for the quick response, works perfect

Regards

Try

=MAX(IF(ISNUMBER(B3:M3),B3:M3))

entered with ctrl + shift & enter

Hi

[quoted text clipped - 16 lines]

Regards