I would like to take the max value of one column where anouther column meets a criteria
C ceemo Jun 17, 2006 #1 I would like to take the max value of one column where anouther column meets a criteria
D duane Jun 17, 2006 #2 here is an example entered as an array formala (control+shift+enter) =MAX(IF(E5:E7=1,D57)) max of d5:d7 subject to e5:e7 being 1
here is an example entered as an array formala (control+shift+enter) =MAX(IF(E5:E7=1,D57)) max of d5:d7 subject to e5:e7 being 1
D Domenic Jun 17, 2006 #3 Try... =MAX(IF(RangeX=Cond,RangeY)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps!
Try... =MAX(IF(RangeX=Cond,RangeY)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps!
7))