I am working in Excel 2010. I am trying to write a formula to calculate a team's

**current**winning/losing streak. I have wins and losses each in their own column, represented by a 1 or a 0. I would like to represent the current streak in a single column where (+) values represent a winning streak and (-) values represent a losing streak.

I have tried multiple combinations of formulas, with varying success. My current formula is: =IF(AS4="1",AP4+1,AP4-1). This works for a continuing winning or losing streak, but the issue arises when a team breaks a streak. For example if they win then lose, or vice versa.

Any help is greatly appreciated. I uploaded my spreadsheet to Google docs here.