seriousdamage
Board Regular
- Joined
- Aug 14, 2005
- Messages
- 58
Hello All,
I am trying to put together a table tennis tracker of my matches.
The part I need help is to calculate the winning % over 10 matches.
So the team can make maximum of 10 point per night
We make 10 point and the % should be 100%, this I can do, where I get stuck is from the second match onwards
The table has 10 columns one per match where I will enter after every much the number of points we made which can be from 0 to 10
On the 11th column I have to total amount of point and on the 12th column I like to have the %
How can I write the formula that will not require me to modify it every time I play a new match?
Many thanks for your help
I am trying to put together a table tennis tracker of my matches.
The part I need help is to calculate the winning % over 10 matches.
So the team can make maximum of 10 point per night
We make 10 point and the % should be 100%, this I can do, where I get stuck is from the second match onwards
The table has 10 columns one per match where I will enter after every much the number of points we made which can be from 0 to 10
On the 11th column I have to total amount of point and on the 12th column I like to have the %
How can I write the formula that will not require me to modify it every time I play a new match?
Many thanks for your help