sorry for the caps bob

cant get this one to work, was looking at the wrong one when i pressed the
'yes' button.
this gives me 0 for everything
Shall try harder to sort it
thanks
--
CHRISK


"Bob Phillips" wrote:

DONT SHOUT!

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

which is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"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