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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAXIF style function 7
Max() Dmax() Looking for MaxIf() Equiv. 5
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Calculate the median value before a specified list 0
Autonumber field in Excel that behaves the same as Access 0
Match Array returning #NA, Works individually 4
Mapping integers to strings 6
maxif 4

Top