WIN/LOSS streaks

I would like to find out win and loss streaks in a column.
for example:

A B C D
-13 -13 -25 51
-5 -10 -8 23
35 -10 -17 -8
50 -5 -25 -20
-7 -2 +15 -6

desired result:

Win-streak
A B C D
2 0 1 2
Lose streak
A B C D
2 5 4 3

How can I get these results?

Thanks in advance

Hi,

Assuming your data given above is in cells A1:D5, enter these array formulae (confirm with CTRL+SHIFT+ENTER, not just ENTER):

In cell A6 and copy across to the right for Win Streak:

=MAX(FREQUENCY(IF(A$1:A$5>0,ROW(A$1:A$5)),IF(A$1:A$5<0,ROW(A$1:A$5))))

In cell A7 and copy across to the right for Lose Streak:

=MAX(FREQUENCY(IF(A$1:A$5<0,ROW(A$1:A$5)),IF(A$1:A$5>0,ROW(A$1:A$5))))

Regards