Total Win Loss Streak Values (Total rather than Running Total)

[Den_Champion]

Hi everyone, probably a simple answer but I cannot work it out. Any help greatly appreciated

I have a working formula in column A that displays Win / Loss Streak in a Running Total format but I want to just see the total of each streak as in Column C showing just the negative results. Is this possible?

 

[Den_Champion]

** Happy to keep the Column A as a helper column then seperate the values from there.

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

See if this does what you want.

20 12 11.xlsm
	A	B	C
1
2	(10.00)
3	(20.00)
4	(30.00)
5	(40.00)		(40.00)
6
7	5.87
8	20.87
9	(10.00)		(10.00)
10	14.00
11	(10.00)		(10.00)
Streak

Cell Formulas
Range	Formula
C2:C11	C2	=IF(AND(A2<0,A3>=0),A2,"")

 

[Den_Champion]

=IF(AND(A2<0,A3>=0),A2,"")

Hi Peter.

Excellent. Works perfectly. Thankyou for your help.
Also thanks for the tip. In future I will will use XL2BB.

 

[Peter_SSs]

You're welcome. Glad it worked for you. Thanks for the follow-up.