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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
