Ah, I should have been able to figure that one out. This one may be a bit
more difficult. Is it possible to calculate a Median for a Track with
SUMPRODUCT (as in column AC)

"T. Valko" wrote:

For Top 5s I tired =SUMPRODUCT(--(Tracks=$C23),--(Finished<=5))

Just add another test:

=SUMPRODUCT(--(Tracks=$C23),--(Finished=1),--(Finished<=5))

--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
Another question relating to this as I have been trying to learn
SUMPRODUCT.....
For Top 5s I tired =SUMPRODUCT(--(Tracks=$C23),--(Finished<=5)) and that
did
not work as the blank cells on the race sheet are all showing 4,394 even
though I was thinking they would show zero. Any ideas on how to formulate
this.

BTW, I found the issue with the Tracks having extra spaces after the
name -
it now has 517 starts as it should.

New sheet at:
http://www.zshare.net/download/173758079330c392/

Thanks for all of your help!