I just posted a clarification at the same time you posted this.

--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
Not if all the values are text

--


Regards,


Peo Sjoblom

"T. Valko" wrote in message
...
MEDIAN ignores text.


--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
You would get that is you have text in the equivalent of the range Biff
called Finished

--


Regards,


Peo Sjoblom

"Brian" wrote in message
...
Hmmm, I tried this and I get a #NUM! error - do you get the same? BTW,
I did
use CTRL,SHIFT,ENTER. Then tried without it and it just gave me a
zero.

"T. Valko" wrote:

Try this array formula** :

=MEDIAN(IF(Tracks=C3,Finished))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP