Calculate WIN/LOSS percentage

[PhilipeC]

I want to calculate the WIN/LOSS percentage from columns H4 to H20. All numbers below 0 would be considered a loss and all numbers above zero a win, and the result = %. Just an example of four numbers H4=10,H5=100,H6=-30,H8=-10 than WIN/LOSS is two wins and two losses resulting in 50%. The result would be only in percetange.

 

[Scott Huish]

WIN formula: =COUNTIF(H:H,">0")/COUNT(H:H)
LOSS formula: =COUNTIF(H:H,"<0")/COUNT(H:H)

Format cells as %

Excel 2010
	H	I	J	K
4	10		WIN %:	50%
5	100		LOSS %:	50%
6	-30
7	-10
8
Sheet1

Cell Formulas
Range	Formula
K4	=COUNTIF(H:H,">0")/COUNT(H:H)
K5	=COUNTIF(H:H,"<0")/COUNT(H:H)

 

[PhilipeC]

Instead of having two cells one for WIN% and another for LOSS% i just want one cell for WIN/LOSS RATE. The WIN would - LOSS , an example: there is five numbers from columns H4 TO H8, H4 = -44, H5=-12, H6=-110,H7=33,H8=56 , than the WIN/LOSS rate would be WINS - LOSSES in percentage , in this case 2 wins and 3 losses resulting in a 40% WIN/LOSS rate which means only 40% of the numbers is positive above zero.

 

[PhilipeC]

Forget about the last post. The formula is working fine.
Thankyou