Calculate the percentage of positive numbers from I4:I20

[PhilipeC]

I want a formula to calculate the percentage of positive numbers from I4:I20, an example if i4=10 i5=32 i6=100 i7=6 i8=-43 i9=-90 , than: 4/6 are positive numbers than 66.6% is the percentage of positive numbers.

 

[njimack]

=countif($i$4:$i$9,">"&0)/count($i$4:$i$9)

 

[RoryA]

You could use:

=COUNTIF(I4:I20,">=0")/COUNT(I4:I20)

Up to you if you want to include 0 as a positive.

 

[PhilipeC]

Hi, the formula result from 5 out 7 positive numbers was 0,29=29,41% but it should be 71,42% , 5 out of 7 the majority is positive?

 

[PhilipeC]

COUNT(I4:I20) is counting 0 , and i have 12 0 values, how to exclude 0?

 

[Joe4]

COUNT(I4:I20) is counting 0 , and i have 12 0 values, how to exclude 0?

Try:

[COLOR=#333333]=COUNTIF(I4:I20,">0")/[/COLOR][COLOR=#333333]COUNTIF(I4:I20,"<>0")[/COLOR]

 

[PhilipeC]

Worked , Thank you

 

[Joe4]

You are welcome. Glad we could help (the previous guys did most of the work; just a matter of making minor tweaks to their responses).
The key is understanding how COUNTIF works.

Here is a good write-up, if you are interested: https://www.techonthenet.com/excel/formulas/countif.php