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...
Bookmarks