Long time visitor, first time poster here. I've always been able to work issues out with formulas but for some reason this one is giving me a massive headache. It's been many hours and I'm no closer. So here it is:

Column A2:Ax has a tally for a win("W"), loss("L"), or tie("T") for a card game. I would like to have an area labeled 1-x to show how many win and losing streaks there are. In other words, how many 1 game win streaks, how many 1 game losing streaks, how many 2 game win streaks, how many 2 game losing streaks.......etc.


bandicam 2015-05-08 22-40-48-210.jpg bandicam 2015-05-08 22-43-41-963.jpg




I've tried max(frequency, countifs, etc and nothing is working.
Formula: copy to clipboard 
=IF(AND(A1<>"W",A2="W"),1,IF(AND(A1="W",A2="W"),#REF!+1,IF(A1<>"W",0,"ERROR")))
This was the latest I tried and it looked promising but when I copied down and then did the "Lose Streak" formula, it all came apart. Here is the losing formula
Formula: copy to clipboard 
=IF(AND(ROW()=2,N1=0),1,IF(N1=0,#REF!+1,0))


Thanks for reading!


EDIT: So far there are 650 or so games tallied with a lot more to input.