=MAX(IF(rng=cond1)*(rng2=cond2)*(rng3=cond3),rng4) )

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Just substitute actual ranges for rng1, 2, 3 and 4 (they must be the same
size), and your test values (enclose in quotation marks if strings).

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Leslie" wrote in message
...
How do I find the MIN and MAX of data based on 3 different conditions?
--
Thanks,
Leslie