From an earlier post of mine today. Note NOT using on complete columns

try this array formula which must be entered using ctrl+shift+enter
=MAX(IF(A2:A22="mytruckcode",B2:B22))
or
=MAX(IF(A2:A22=c2,B2:B22))


--
Don Guillett
SalesAid Software

"Fred Smith" wrote in message
...
I have a sumif formula, as in:

=sumif(I:I,a2,J:J)

I also want to calculate the maximum of the values which meet the
criteria. Is this possible?

--
Regards,
Fred