Prev: Can't Edit Worksheet Comments
Next: Macro help - add column selection
From: rwtrader on 4 Jun 2010 09:24
Was this function removed from 2007 or do I just need to download an add-in?
From: Bernard Liengme on 4 Jun 2010 09:36
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

"rwtrader" <rwtrader(a)discussions.microsoft.com> wrote in message
news:C20F4DE5-C0B8-4476-A36B-B6390DCA9A21(a)microsoft.com...
> Was this function removed from 2007 or do I just need to download an
> add-in?

 | 
Pages: 1
Prev: Can't Edit Worksheet Comments
Next: Macro help - add column selection