Something like

=MAX(IF(Range10,Range))

array entered

--
Regards,

Peo Sjoblom

(No private emails please)


"Becky" wrote in message
...
I am a newbie to Excel. I have a spreadsheet for a class in which I am
required to find the most sales by using IF and MAX. Also, I must find
the
least sales using IF and MIN. Can anyone help me put a formula together?