Median IFS Formula inconsistent results between worksheets

[anonymous8472]

On worksheet Deals!, where P246 is the range of deals in 2005;


=MEDIAN(P246) returns $500,000


On worksheet Statistics!, where cell AA2 has a value of 2005;


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


How can I get the correct number on worksheet statistics?


This is also posted in thread "Median IFs Help"

 

[Montrey]

Use the formula Auditing toolbar function. Your worksheet stats sheet is pulling different data

 

[anonymous8472]

Is the statistics sheet formula sketchy?

 

[Haseeb A]

Xeno,


This is an Array Formula, so you must hit CTRL+SHIFT+ENTER NOT just ENTER


If you done successfully, you can see formula surrounded by {}

 

[anonymous8472]

Thanks Haseeb. You are right, problem fixed. I didn't do that in your original instructions. Thanks very much!