If there are no cells that meet the criteria then you'll get that error.

In your updated file, I enter the array formula** in AC3 and copy down to
AC15. Out of all those cells only 2 return a number.

Atlanta = 2
Bathurst = 8.5

All the others return #NUM! because there is no data for those tracks.

--
Biff
Microsoft Excel MVP


"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