I have a list of 3288 items, I want to find the median of FCFY those items with a p/e value greater than one. There are 2 columns: p/e value and FCFY.

I think the formula should look like this but it doesn't work..

=IF(B4:B32881,MEDIAN(C4:C3288))
English: Find the median of C's value for all B's that are greater than 1.

Thanks for your help!!