Complicated COUNTIF on a filtered array

This may be a lot to ask, but I need to at least know if this is doable.
First of all the formula should only count the visible cells because the data is affected by auto-filter "by surface"

COUNTIF L2:L5000 = either "2-1" or "1-2" more than 4 times in a row, and if so, how many times

To clarify, any of the two values will count, it can be "1-2", then" 2-1", then "1-2", then "2-1", and it will count as a series of 4.

If it can be done but not on auto-filtered data, then I must be able to apply another condition, that the formula should count only if the "Surface" is "hard".
Thanks

With an pivot table.

Sheet the result in the attached file.

Please reply.

Thank you for taking the time to answer.
Unfortunately I don't think I explained properly what I need.
The answer I need is : the maximum number of consecutive instances where the L (set score) cell is "2-1" or "1-2", or in other words, the maximum number of consecutive matches where has Annika Beck played 3 sets (2-1 or 1-2 means she played 3 sets in the respective match).
I know nothing about pivot tables so I don't know how to modify it to get the answer I want.
Thanks again!

To count how many runs of 4+ there are you can use this "array formula"

=SUM(IF(FREQUENCY(IF((L$2:L$300="2-1")+(L$2:L$300="1-2"),IF(F$2:F$300="Hard",ROW(F$2:F$300))),IF(L$2:L$300<>"2-1",IF(L$2:L$300<>"1-2",IF(F$2:F$300="Hard",ROW(F$2:F$300)))))>=4,1))

confirmed with CTRL+SHIFT+ENTER

The formula only considers hard surface matches - easier to do that than consider only visible data

For your data as it stands that formula will return zero because there are no runs > 3. I suggest you manually create some longer runs to test the formula

Thanks, I was thinking about an array, but I was on the wrong track, you mentioned a few days ago, something about OFFSET creating an array but it seemed very complicated that way..
I'll test it and reply!
Edit: Awesome, it seems to be working!!! Many thanks! I guess now I'll spend the rest of the day analyzing your formula.