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