Using Median IF to calculate the median for a specific criteria

I have two columns of values (ONI - Column D and Temps - Column E). I need to calculate the median of Temps when the ONI is in the 0.5 and 0.9 range, 1.0 and 1.4 range, and 1.5 and greater. Below is the formula that I am using to calculate the median temperature when the ONI is in the 0.5 and 0.9 range.

=MEDIAN(IF(($D$5:$D$26>=0.5*($D$5:$D$26<=0.9)),$E$5:$E$26))

It is producing differing values than if I just manually calculate the median for these cells.

=MEDIAN(E5:E14)

What am I doing wrong in my first formula?

Thanks for any help!

Hi,

Try below array formula:

=MEDIAN(IF((($D$5:$D$26>=0.5)*($D$5:$D$26<=0.9)),$E$5:$E$26))

Red bracket is the portion that you missed.

Thanks! That did the trick. I really appreciate your help with this.

Thanks for the feedback , you can mark the thread as solved and if you like you can give some reps points to members by clicking the add reputation button below the comments if you think the solution helped you.

How do you mark it as solved?

Jeff

Thanks!

Jeff