Calculating streaks when some cells are blank

[HBTim67]

I am trying to calculate winning and losing streaks, but some of my cells do not contain information because a team might not play on that current day. How can I have a formula that will over look a blank cell, but still have it continue a streak?

Example

Cell A1. W
A2. L
A3. W
A4.
A5. W
A6. W

I should have a streak of 3 wins, but every time I try a formula it will only calculate it as 2 wins. How do I have a formula overlook the blank cell?

And then I need it to calculate the longest streak as well.


Any and all help would be greatly appreciated

Thank you,

Tim

 

[Eddie29]

Hi! I've had the same problem as you, counting current win/loss/tie streaks. I've been using the formula below and it's ok, except it doesn't work when there are blank cells in the range:

[FONT=&quot]=LOOKUP(1E100,FREQUENCY(IF(B2:B7=LOOKUP("zzz",B2:B7),ROW(B2:B7)),IF(B2:B7<>LOOKUP("zzz",B2:B7),ROW(B2:B7))))&"[/FONT]
[FONT=&quot]"&LOOKUP("zzz",B2:B7)[/FONT]

Can anyone help me please, by making the formula ignore blank cells? Thks!