Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|