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)
 
Top