ExcelBanter - excel percent using countif

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - excel percent using countif (https://www.excelbanter.com/new-users-excel/236866-excel-percent-using-countif.html)

Jeremy

excel percent using countif

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

Otto Moehrbach[_2_]

excel percent using countif

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

"jeremy" wrote in message
...
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

All times are GMT +1. The time now is 07:24 PM.