calculating median of one range based on conditions in another range

[rokoexcel]

Hi,

I have two columns with numbers, let's call them A & B, and need to calculate the median of numbers in B that are associated with A's greater than 1. Doing this in one step with "median if" array (=MEDIAN(IF($B$4:$B$3288>"1",$C$4:$C$3288, )) resulted in 0, but doing it in two steps, with a helper column resulted in -0.02. Both methods appear identical to me, though the results are different.

What is the correct method?

Thank you!

 

[Takae]

=MEDIAN(IF(B4:B3288>=1,C4:C3288))
press Shift+Ctrl+Enter simultaneously. It be added "{}" automatically.

 

[rokoexcel]

=MEDIAN(IF(B4:B3288>=1,C4:C3288))
press Shift+Ctrl+Enter simultaneously. It be added "{}" automatically.

Thank you Takae.

I had already tried C+S+E. I did figure it out. It turns I needed to ensure the formula replaced all FALSE with blank space, instead of 0, with the following formula.

{MEDIAN(IF(B4:B3288>=1,C4:C3288, "")}

Thanks for your feedback anyway!