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!