Please Help !! Median Range Formula

Hi - I am trying to get the median of a large number of values in a column range example rows (c.3000)- such that the formula ignores zero / errors or blanks. Additionally, I want to be able to apply a filter and that the result is just using the filtered visible dataset. I have used the formula below, but it is giving me a value I don't think is correct.  Any help would be really appreciated:

=MEDIAN(IF(SUBTOTAL(2,OFFSET(V9,ROW(V9:V2999)-ROW(V9),0)),V9:V2999))

Sometimes this gives value and sometimes a blank and I am not sure why.

In a linked sheet, I was using the cell values above but with each of the cells linked using :

=+IF(FINAL!V10=0,"",(FINAL!V10))

So that it ignored the Zero's but all in all I think I might be just confusing the issue

I need the second sheet so that I can subdivide the set by filter again but maintain sight of the larger filtered value. - Its to do with price-earnings of shares.

Thank you so much