median if- returning 0

[bloodybrit90]

Hey guys,

The following array formula returns 0. Any Ideas why?


=MEDIAN(IF('textexport(1)'!$O:$O=Sheet3!A2,'textexport(1)'!$P:$P,))

Since pivot tables do not have a median option I have all the days (1/1/2005-12/31/2011) in column A and want the median for each. If anyone has a suggestion on a better method please let me know. I am trying to graph these medians after.

Cheers.

 

[Robert Mika]

Did you confirm your formula with CONTROL+SHIFT+ENTER?

=MEDIAN(IF('textexport(1)'!$O:$O=A2,'textexport(1)'!$P:$P))

You do not need the last ","
This is array formula.

 

[bloodybrit90]

the "," was the issue. Thanks Robert

 

[Robert Mika]

You are welcome.