this works for half
what is the ctrl shift enter bit?
--
CHRISK


"Mangesh Yadav" wrote:

Use:

=MAX(A1:A4*(B1:B4="a"))
confirm with control - shift - enter
And similar for min

Mangesh




"CHRIS K" wrote in message
...
HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA) &
HOW DO I GET THE EQUIVALENT OF MINIF(RANGE,CRITERIA)?
i've tried loads of rubbish but cant get the answer i want.
--
CHRISK