View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
 
Posts: 683
Default LOOKUP, FREQUENCY etc - what's the best way

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!