MEDIAN formula not working

[johns99]

Hello,

For some reason the below formula is not working and I cannot figure out why?

{=IFERROR(MEDIAN(IF(('Personnel Report-ESG'!$W$2:$W$1668='Key City Location'!B3)*('Personnel Report-ESG'!$BD$2:$BD$1668='Key City Location'!$A$1)*('Personnel Report-ESG'!$AL$2:$AL$1668<>""),$AL$2:$AL$1668))/1000,"")}

Any ideas?

Thanks,

John

 

[johns99]

I went ahead and used this and it worked...

{=IFERROR(QUARTILE.EXC(IF(ISNUMBER(MATCH('Personnel Report-ESG'!$W$2:$W$1668,'Key City Location'!B3,0)),IF(ISNUMBER(MATCH('Personnel Report-ESG'!$BD$2:$BD$1668,'Key City Location'!$A$1,0)),IF('Personnel Report-ESG'!$AL$2:$AL$1668<>"",'Personnel Report-ESG'!$AL$2:$AL$1668))),2)/1000,"")}


But I'm still curious as to why the first formula did not work, any feedback would be appreciated.

Thanks,

John

 

[steve the fish]

I just used it and it worked fine.

 

[johns99]

The first one?

 

[steve the fish]

Yeah. No problems with it. Obviously removed your sheetnames but that makes no difference to structure of the formula.

 

[johns99]

I guess it may have been something in one of the cells?

Well good to know it worked, thanks for your feedback.

John