Excel: need a "maxif" function!!

N

Nick

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??
 
A

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.
 
M

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.
 
Top