median formula help needed

[knifey]

Hi,

I have an averageif formula that I'm trying to adapt (unsuccessfully) to give me the median instead. Can anyone advise where I'm going wrong or a better way of doing this?

AverageIf works:
=AVERAGEIF(OFFSET(Source!$A$1,1,MATCH("Incident status",Source!$1:$1,0)-1,COUNTA(Source!$A:$A),1),$C15,OFFSET(Source!

Median doesn't work:
{=MEDIAN(IF(OFFSET(Source!$A$1,1,MATCH("Incident status",Source!$1:$1,0)-1,COUNTA(Source!$A:$A),1)=$C15,OFFSET(Source!$A$1,1,MATCH("Creation to today",Source!$1:$1,0)-1,COUNTA(Source!$A:$A),1)))}

Thanks,
K

 

[combo]

Try non-array formula. Check IF function, currently you have:
..IF(OFFSET(..)=$C15, OFFSET(...))
This returns FALSE if condition is FALSE, you need range.

combo