Excel: need a "maxif" function!!

[Guest]

I need a function similar to "sumif", but instead of summing certain values,
will select the largest value from an array that is a constrained by values
in a separate column of the array. does anyone have any ideas on this??

 

[Aladin Akyurek]

=MAX(IF($A$2:$A$100="X",$B$2:$B$100))

whuch you need to confirm with control+shift+enter instead of just with
enter.

 

[R.VENKATARAMAN]

is there not a <dmax> function which
"Returns the largest number in a column in a list or database that matches
conditions you specify"

see help with key word as dmax

 

[Myrna Larson]

Certainly there is, but it requires that pesky "criteria range", which is real
barrier for most people. And if you have several of these functions, each with
different criteria, it makes DMAX close to useless, IMO.