need formula for 80% and above
 

I need a formula to figure the percent of entries above 80%?

Example:
100%
100%
10%
100%
10%
--------
60% are above 80%

Thanks!

need formula for 80% and above
 

Try something like

=COUNTIF(A1:A10,"=0.8")/COUNT(A1:A10)

Change the A1:A10 to the range you need. Change the = to if
you don't want to include entries that are exactly 80%.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"novice 1" <novice wrote in message
...
I need a formula to figure the percent of entries above 80%?

Example:
100%
100%
10%
100%
10%
--------
60% are above 80%

Thanks!