Median as an Array does not ignore blanks

Hi All,
Help please! Struggling with this one.

Using a mean formula it will automatically ignore blanks. That is great...exactly what I need it to do. However, when you use it in an array it no longer ignores blanks and give you a different answer. I need it to ignore blanks so I can use it as a 'meanif' formula.

Description Median Totals
Type 1 0.48
Type 1 2.82
Type 1
Type 1 4.56
Type 1 1.62
Type 1 0.82
Type 1 -3.35
Type 1 -10.82
Type 1 6.33


Type 2 50000

Type 1 Median 1.22

Median as an Array
0.82095


=MEDIAN(IF($A$2:$A$19987=$A2,B$2:B$19987))

The answers match if I type a number over the blank but I will have valid blanks in many scenarios.

Thanks!!!

This should work..

=IF(ISBLANK(A2),MEDIAN(IF($A$2:$A$19987=$A2,B$2:B$19987)))

Originally Posted by day92

This should work..

=IF(ISBLANK(A2),MEDIAN(IF($A$2:$A$19987=$A2,B$2:B$19987)))

This looked good but it just gives me an answer of FALSE

Originally Posted by NBVC

Add another nested IF



=MEDIAN(IF($A$2:$A$19987=$A2,IF(B$2:B$19987<>"",B$2:B$19987)))

This doesn't seem to work either. I am just getting a answer of 0.

Originally Posted by NBVC

Are you sure.. I got 1.22 in my test.

Did you confirm with CTRL+SHIFT+ENTER?

Yes I made sure to use the ctrl+shift+enter. Any chance you can attach your example file so I can look at it closer? It is probably something I am doing but I can't seem to figure out what that is. Your example would help. Thanks!

Wow! Thank you! You rock!

This works perfectly!

(BTW I pasted my example in a bad location and had a circular reference which is why I was getting zero)