# How to calculate current win/loss/tie streak in Excel?

#### smcmahon83

##### Board Regular
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.

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### Eric W

##### MrExcel MVP
Perhaps:

ABC
1ResultStreak
213 Win
31
41
50
6-1
7-1
81
90
101
110
12-1
13-1
14-1
150
160
170
181
191
201
21

</tbody>
Sheet3

Worksheet Formulas
CellFormula
C2=COUNTA(A:A)-LOOKUP(2,1/((\$A\$2:\$A\$100<>INDEX(A:A,COUNTA(A:A)))*(\$A\$2:\$A\$100<>"")),ROW(\$A\$2:\$A\$100))&CHOOSE(INDEX(A:A,COUNTA(A:A))+2," Loss"," Tie"," Win")

</tbody>

<tbody>
</tbody>

Replies
3
Views
115
Replies
23
Views
2K
Replies
23
Views
259
Replies
4
Views
53
Replies
3
Views
366