smcmahon83
Board Regular
- Joined
- Jul 12, 2014
- Messages
- 58
Hello,
In column M, I have the following scoring system:
Win = 1
Tie = 0
Loss = -1
Can anyone recommend a formula, where I can calculate the current win/loss/tie streak? For example, if the last 4 results have all been losses, the formula would return -4 for the current streak. If the following game resulted in a tie(0), the streak would reset to 0, etc.
Thanks a million in advance to anyone who might be able to help here.
In column M, I have the following scoring system:
Win = 1
Tie = 0
Loss = -1
Can anyone recommend a formula, where I can calculate the current win/loss/tie streak? For example, if the last 4 results have all been losses, the formula would return -4 for the current streak. If the following game resulted in a tie(0), the streak would reset to 0, etc.
Thanks a million in advance to anyone who might be able to help here.