Winning streak that reset when broken Google Sheets

[Gigiwan]

Hi
I managed to create a formula with someone's else help but the problem is that formula start counting from 4 where it supposed to start counting from 1 or 0 in first cell ( attached photo of my table) then it keep on counting until streak is broken by another character "anything else than win"
Formula used:
=ARRAYFORMULA(MAX(IF(B4:B38<>"",ROW(B4:B38),0))-MAX(IF((B4:B38<>"")*(B4:B38<>"Win"),ROW(B4:B38),0)))
How can i fix it?

 

[Fluff]

Hi & welcome to MrExcel.
Is this for Excel or Google Sheets?

 

[Gigiwan]

Hi & welcome to MrExcel.
Is this for Excel or Google Sheets?

Thanks, google sheets

 

[Fluff]

Ok, in future you should clearly state that it's for Sheets, as Sheets & Excel are not the same.
You should also post Sheets questions in the General Discussion & Other Applications section of the board.
I have done this for you this time.

 

[Fluff]

If you are trying to get the current win streak try

=ARRAYFORMULA(MAX(IF(B4:B38<>"",ROW(B4:B38)-ROW(B4)+1,0))-MAX(IF((B4:B38<>"")*(B4:B38<>"Win"),ROW(B4:B38)-ROW(B4)+1,0)))

 

[Gigiwan]

If you are trying to get the current win streak try

=ARRAYFORMULA(MAX(IF(B4:B38<>"",ROW(B4:B38)-ROW(B4)+1,0))-MAX(IF((B4:B38<>"")*(B4:B38<>"Win"),ROW(B4:B38)-ROW(B4)+1,0)))

Apologies for not acknowledging the sub forums, but thanks for your cooperation and your understanding that I'm a Rookie .

The formula you have wrote work flawlessly as needed!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Gigiwan]

You're welcome & thanks for the feedback.

My pleasure, one more thing
if i got blank cell how can i make it reset counting?

 

[Fluff]

I don't use Sheets, so not sure I can help with that.