Formula result function MAX IF

ree001 · Apr 24th, 2002, 03:42 AM

I want the MAX from column C2:C9 IF in column
A2:A9 = x (see below)

I use this formula:

=MAX(IF(A2:A9="x",(C2:C9)))

The result is 90 ???

But if pressing the edit formula button "="
the formula result shows "70"

A2:A9 C2:C9
x >>>>>>>>>>>> 20
>>>>>>>>>>>> 30
x >>>>>>>>>>>> 50
>>>>>>>>>>>> 10
>>>>>>>>>>>> 60
x >>>>>>>>>>>> 70
>>>>>>>>>>>> 90
x >>>>>>>>>>>> 45

Who can help me out on tis one.

[ This Message was edited by: ree001 on 2002-04-24 02:53 ]

[ This Message was edited by: ree001 on 2002-04-24 02:58 ]

Aladin Akyurek · Apr 24th, 2002, 04:21 AM

=MAX(IF(A2:A9="x",C2:C9))

should be entered as an array-formula, that is, you need to hit control+shift+enter at the same time, not just enter.

Aladin

ree001 · Apr 24th, 2002, 05:22 AM

Bedankt, het werkt

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 03:42 AM	#1
ree001 New Member Join Date: Apr 2002 Location: Netherlands Posts: 6	I want the MAX from column C2:C9 IF in column A2:A9 = x (see below) I use this formula: =MAX(IF(A2:A9="x",(C2:C9))) The result is 90 ??? But if pressing the edit formula button "=" the formula result shows "70" A2:A9 C2:C9 x >>>>>>>>>>>> 20 >>>>>>>>>>>> 30 x >>>>>>>>>>>> 50 >>>>>>>>>>>> 10 >>>>>>>>>>>> 60 x >>>>>>>>>>>> 70 >>>>>>>>>>>> 90 x >>>>>>>>>>>> 45 Who can help me out on tis one. [ This Message was edited by: ree001 on 2002-04-24 02:53 ] [ This Message was edited by: ree001 on 2002-04-24 02:58 ]

Apr 24th, 2002, 04:21 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	=MAX(IF(A2:A9="x",C2:C9)) should be entered as an array-formula, that is, you need to hit control+shift+enter at the same time, not just enter. Aladin

Apr 24th, 2002, 05:22 AM	#3
ree001 New Member Join Date: Apr 2002 Location: Netherlands Posts: 6	Bedankt, het werkt