Max
 

I would like to take the max value of one column where anouther column
meets a criteria


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=552924

Max
 

here is an example

entered as an array formala (control+shift+enter)

=MAX(IF(E5:E7=1,D5:D7))

max of d5:d7 subject to e5:e7 being 1


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=552924

Max
 

Try...

=MAX(IF(RangeX=Cond,RangeY))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
ceemo wrote:

I would like to take the max value of one column where anouther column
meets a criteria

Max
 

a bit more detail

--
Don Guillett
SalesAid Software

"ceemo" wrote in
message ...

I would like to take the max value of one column where anouther column
meets a criteria


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=552924