Hi Steven.............

You could do Data Filter AutoFilter............then select your group of
interest and sort decending on your column of interest..........that would
put the MAX value of that subset at the top of that column............

hth
Vaya con Dios,
Chuck, CABGx3


"Steven" wrote in 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