Calculating consecutive wins

[ChaosTrader63]

Hello all! I am trying to find the formula to calculate consecutive wins from my journal spreadsheet in cell "L" onto my Overview spreadsheet in cell "N 12". I don't do much excel formulas so I would need to understand how to enter this so it calculates from one sheet onto another sheet. I have attached 2 pics to explain and also the journal. I do appreciate all the help. Thanks!

 

[ChaosTrader63]

I have solved this formula but thank you!

 

[Luke M]

In N12 of your overview sheet, put this formula:
=MAX(FREQUENCY(IF(Journal!L2:L201="Win",ROW(Journal!L2:L201)),IF(Journal!L2:L201<>"Win",ROW(Journal!L2:L201))))

Confirm formula as an array using Ctrl+Shift+Enter, not just Enter.