I need a formula to figure the percent of entries above 80%? Example: 100% 100% 10% 100% 10%
N novice 1 Jun 1, 2006 #1 I need a formula to figure the percent of entries above 80%? Example: 100% 100% 10% 100% 10%
C Chip Pearson Jun 1, 2006 #2 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
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
