Help needed with Horse Racing Forumla

rileybro

New Member
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

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sorry I meant 10% in D2 not C2

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

Replies
4
Views
303
Replies
16
Views
480
Replies
0
Views
522
Replies
8
Views
516
Replies
8
Views
3K

1,203,075
Messages
6,053,394
Members
444,661
Latest member
liamoohay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back