Median Ifs, need to find median $ amount per deal for each year

Hello,

I need to find the Median $ amount earned for deals done from 2005-2012, in current worksheet Statistics! from worksheet Deals!.

=MEDIAN(IF(TEXT(Deals!$C$2:$C$500,"yyyy")=AA2&"",Deals!$P$2:$P$500))

I've been having problems with this formula I was given from another forum. Is it legitimate? It's pulling a totally random number, $398,412.00, when the median formula on the actual deals worksheet pulls $500,000.

The date column in Deals! are formatted numerically in dd/mm/yyyy format.

Current worksheets AA2-AA9 are labeled 2005:2012.

Thanks for any help...