Median of Column E Where Column K=X

[jes269]

I am using the following formulas and have the following errors/problems. Please help. Thank you in advance.

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999=0,'Case Management'!#REF!)))}
=NUMBER ERROR

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999=1,'Case Management'!$E1:$E9999)))}
=CORRECT

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999=2,'Case Management'!$E2:$E10000)))}
=THE OUTPUT VALUE IS NOT CORRECT

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999=3,'Case Management'!$E3:$E10001)))}
= CORRECT

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999="r",'Case Management'!$E4:$E10002)))}
= THE OUTPUT VALUE IS NOT CORRECT

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999="t",'Case Management'!$E5:$E10003)))}
= THE OUTPUT VALUE IS NOT CORRECT

[JieJenn]

Your array has to be consistent. Change E5 to E1003 to E1 to E9999

{=MEDIAN(IF('Case Management'!$K$1:$K$9999<>"",IF('Case Management'!$K$1:$K$9999="t",'Case Management'!$E5:$E10003)))}

[jes269]

Thanks, fixed now, although that did not solve the problem. All the number 1s are sorted at the top of that column, so the mistake you found doesn't affect anything in the above outputs.

[jes269]

I think I got them all working. Thanks.