That's for sure! Thanks - that worked.

"T. Valko" wrote:

Something to consider...

Your file is already "kind of big", 5mb, and it's already exhibiting slow
calculation times. I see all those other columns where you intend to do
calculations and it looks like most of them are going to end up being array
formulas. So, you need to start making things as efficient as possible. With
that in mind:

=IF(SUMIF(Tracks,C3,Finished),MEDIAN(IF(Tracks=C3, Finished)),"-")

array entered

--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
Yes, Peo, some cells have text, but Biff is right - MEDIAN ignores text.
I
guess the next logical question is how best to frame the formula so that
tracks without data get a "-".


"T. Valko" wrote:

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