There has never been a MEDIANIF
But this will fond the median of value > 10 in the range
=MEDIAN(IF(A1:100>10,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/Forums/en-US/category/officeexcel
