Looking for current streak formula

[15minoffame]

Hi again,
I have a spreadsheet that shows a list of stocks. I'm looking for a formula to show the current winning or losing streak. In this case A1 should be 6.

This is an example.

A	B	C	D	E	F	G	H	I	J	K	L
6	3.05	5.24	1.28	0.45	1.14	2.40	-.98	7.14	-2.78	-.50	3.14

<tbody>
</tbody>

Thanks again!

 

[Peter_SSs]

Remembering that your readers know nothing about your sheet or what you are trying to achieve apart from what you say/show, it would make things easier for them if you gave a fuller explanation.

So guessing then that ..
- column A holds the expected result
- the most recent values are at the left, apart from column A
- a winning/losing streak consists of a series of numbers of the same sign

Try this, copied down

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	6	3.05	5.24	1.28	0.45	1.14	2.4	-0.98	7.14	-2.78	-0.5	3.14
2	1	-6	5	2
3	11	6	6	6	6	6	6	6	6	6	6	6
4	0
5	4	-2	-9	-6	-7
Streak

 

[15minoffame]

Hi Peter,
My apologies. I should've titled my rows Month. I will certainly remember this the next time I need help. I really appreciate your help! Your formula worked wonderfully! How would I change the formula to change A5 to -4 since there are four negative numbers in a row.

Thanks again!

 

[Peter_SSs]

How would I change the formula to change A5 to -4 since there are four negative numbers in a row.

Change my A1 formula to

=IFERROR(MATCH(TRUE,INDEX(SIGN(B1:L1)<>SIGN(B1),0),0)-1,COUNT(B1:L1))*SIGN(B1)

 

[15minoffame]

Thank you again Sir! You're a gentleman & a scholar!

 

[Peter_SSs]

Thank you again Sir! You're a gentleman & a scholar!

You are very welcome. Thank you also.