excel percent using countif

J

jeremy

i have a range of cells that have a if formula for pass/fail. i want to input
in a new cell the percent of the students that passed
 
O

Otto Moehrbach

Something like this perhaps. HTH Otto
=COUNTIF(A1:A10,"Pass")/COUNTA(A1:A10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Relative Percent Difference... 2
Using <= in countifs statement 1
Percent Help 2
Nested if statements creating a blank cell 1
Combining Percent with Text 5
Excel - Wich Function should I use? 1
Excel Percents formatted for 1 decimal place 3
Help to convert merge codes from 2003 to 2010 0

Top