There has never been a MEDIANIF
But this will fond the median of value 10 in the range
=MEDIAN(IF(A1:10010,A1:A100)
Note that it is an array formula and must be completed using
CTRL+SHIFT+ENTER
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/...ry/officeexcel

"rwtrader" wrote in message
...
Was this function removed from 2007 or do I just need to download an
add-in?