#### seriousdamage

##### Board Regular

- Joined
- Aug 14, 2005

- Messages
- 58

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