There is no MAXIF function, but you can use an array
formula. For example, return the maximum value in A1:A100
if B1:B100 = "dog":

=MAX(IF(B1:B100="dog",A1:A100))

2 important notes:

1. This is an array formula, so you must press
ctrl/shift/enter, not just enter, after inserting the
formula and anytime you edit the cell. XL will place {}
around the formula.

2. Array formulas cannot handle entire columns. You
cannot use:

=MAX(IF(B:B="dog",A:A))

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I am doing a SumIF( , , ) and that works fine. Is
there a way to do a
>MaxIf( , , ). I see in the help that there is no
Maxif but what I want to
>do is return the highest value for that particular
occurance in the same data
>that I am doing the SumIF.
>
>Thank you for your help.
>
>Steven
>.
>