MaxIF?

[Ann Scharpf]

Is it possible to create a formula to do
MAX/MIN/LARGE/SMALL type functions only if cells meet a
certain condition? (Like the SUMIF function.)

I have been trying to do this for a while, looking through
the functions, help and so forth. Not finding any way to
do it so far.

TIA.

Ann Scharpf

 

[Vasant Nanavati]

Hi Ann:

For example:

=MAX((B26:B30)*(B26:B30<>0))

entered as an array formula with <Ctrl><Shift><Enter> instead of <Enter>.

Regards,

Vasant.