Median with conditions

[Berrett]

I have a formula that says this:

{=MEDIAN(IF($F$5:$F$50="n",I5:I50))}

This works fine for what I'm doing, but if there are no data at all in column "I" for a record that is marked as "n" in column "F" it counts that record as a zero. What can I do to modify this formula so that it returns the median only for those records that are marked as "n" in column "F" and that have data in column "I"?

Thanks.

 

[Domenic]

Try...

=MEDIAN(IF($F$5:$F$50="n",IF(ISNUMBER(I5:I50),I5:I50)))

...confirmed with CONTROL+SHIFT+ENTER.

 

[T. Valko]

I have a formula that says this:

{=MEDIAN(IF($F$5:$F$50="n",I5:I50))}

This works fine for what I'm doing, but if there are no data at all in column "I" for a record that is marked as "n" in column "F" it counts that record as a zero. What can I do to modify this formula so that it returns the median only for those records that are marked as "n" in column "F" and that have data in column "I"?

Thanks.

Here's another one...

Still array entered**:

=MEDIAN(IF($F$5:$F$50="n",IF(I5:I50<>"",I5:I50)))

** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

 

[Berrett]

Thanks! That did the trick.

 

[T. Valko]

Thanks! That did the trick.

You're welcome. Thanks for the feedback!