J jeremy Jul 14, 2009 #1 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
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 Jul 14, 2009 #2 Something like this perhaps. HTH Otto =COUNTIF(A1:A10,"Pass")/COUNTA(A1:A10)
