Formula

[jcfite]

I have a fairly easy question. I have scores ranging from 0-100. Lets just say I have 8 of them from A:1-H:1. I want in I:1 to calculate the percentage of all scores greater than 85. So out of all the scores it is is 85 and above then it will give me the percentage of that. So if only 4 scores were at 85 or above then 50% will come up. Any suggestions will help. Thanks

 

[mjd1972]

=COUNTIF(A1:H1,">84")/COUNTIF(A1:H1,">0")

Make sure you format I1 as percentage

 

[VoG]

Try

=100*COUNTIF(A1:H1,">85")/COUNT(A1:H1)

 

[jcfite]

Thanks guys I will put that in and let you know what I get. I think my problem has been solved because I was not putting that field as a percentage.

 

[jcfite]

Works perfectly. VoG - needs to be 84 because formula is looking for 86 and above.