Excel Percentage

[Binder]

Hello

Can anyone tell me how to enter the percentage of times a factor
happens in a cell below the 31 and 28 cells

For example a horse that was in the top 5 speed rating has won
28 times in 31 races
I would like to have the winning percentage figure in the cell
below the 28 and 31

Also is it possible for this to be a running total ?

Lest say the next race I enter, and the winner does not have the top 5-speed
rating, then it will say 32 races and still 28 times

Can the winning percentage update again automatically?
thanks
Binder

Percent.PNG

[Ted Craven]

Bill,

Use the formula in the attached image. Simply: the Count cell divided by the Races cell. Format the Percent cell as Percentage%

percent.jpg

When you change the value in Races, for example to 32 (or the value in Count), the Percentage will update automatically.


Ted

[Binder]

Hey Ted
Thank you so much , once again happy New Year

Bill