Sorry in advance first, my english is not very good. But I really hope someone can help me on this.

I need do something to make this happen.

Example:

I had 2 columns, 1 for win, 1 for loss and 1 row for unbeaten runs

First, I will like 5 wins and 0 losses to the column, then the unbeaten runs will show up "5".

Second, when I add 1 loss to the column, the unbeaten runs will reset to "0"

So basically, what I wanted to do is, whenever I key in a win, it will added up to the Unbeaten Runs row until I added a loss to the loss column then the Unbeaten Runs row will reset to 0.


Hope someone can help me on this.