Help needed with Horse Racing Forumla

[rileybro]

Hi Guys

I am hoping to include a formula which would estimate the % horse B would beat horse A based on a single run time for horse A and multiple run times for Horse B. The spreadsheet is set up as described below

Column A2 - Horse A's run time
Column B2:B10 - Horse B's run times
Column C2:C10 - % Likelihood of Horse B's run time occurring

I was hoping to then include the % likelihood that horse B would beat Horse A's run time in Column D2.

Therefore if Horse A's run time was 27.00 and Horse B has two run times faster than that say 26.9 & 26.95, both of which occur 5% of the time. I would need the formula to show 10% in Column C2.

I hope that makes sense.

Any help would be appreciated.

Thanks

 

[rileybro]

Sorry I meant 10% in D2 not C2

 

[West Man]

Try:

=SUMIF(B2:B10,"<"&A2,C2:C10)