Count consecutive wins

[livermore]

Hello.

I want to count the number of consecutive wins in a table.
Below I have an example.

$40
-$20
$25
$10
$5
$41
$32
-$5
$9
-$12

<tbody>
</tbody>

My goal is to be able to count how many consecutive wins I was able to get.
The example shows 4 consecutive wins

$25

$10

$5

$41

$32

<tbody>
</tbody>

I believe I need to use the FREQUENCY function but I'm completely lost regarding the bin.

Can you help me?
What the formula to achieve this?
Thank you.

 

[Eric W]

Try:

=MAX(FREQUENCY(IF(A1:A10>0,ROW(A1:A10)),IF(A1:A10<0,ROW(A1:A10))))

with Control+Shift+Enter.

 

[livermore]

This is it!
Many thanks.

Allow me to do another question.
I have a similar situation as below:

-$50
$45
$6
$32
$4
$56
$21
-$45
-$12

<tbody>
</tbody>

Using your formula I would get 6 consecutive wins but there's a blank space between $4 and $56.
The formula is not taking the blank space in consideration, which would mean 4 consecutive wins and not 6.

Tried this formula:
=MAX(IF(ISNUMBER(A1:A10),FREQUENCY(IF(A1:A10>0,ROW(A1:A10)),IF(A1:A10<0,ROW(A1:A10)))))

But I'm getting a #N/A result

Regards.

 

[Nishant94]

This is it!
Many thanks.

Allow me to do another question.
I have a similar situation as below:

-$50
$45
$6
$32
$4
$56
$21
-$45
-$12

<tbody>
</tbody>

Using your formula I would get 6 consecutive wins but there's a blank space between $4 and $56.
The formula is not taking the blank space in consideration, which would mean 4 consecutive wins and not 6.

Tried this formula:
=MAX(IF(ISNUMBER(A1:A10),FREQUENCY(IF(A1:A10>0,ROW(A1:A10)),IF(A1:A10<0,ROW(A1:A10)))))

But I'm getting a #N/A result

Regards.

Just a modification to Eric's Formula. Try this:

=MAX(FREQUENCY(IF(A1:A10>0,ROW(A1:A10)),IF(A1:A10<=0,ROW(A1:A10))))

 

[livermore]

Brilliant!

Easier than I thought.

Many, many thanks!