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