CODEWITHSUNDEEP
excel
Hunar
Hunar

Reputation: 399

How to calculate student pass percentage in excel

In Excel I have a list of students that do an exam, some of them passed the exam and others are failed. I want to calculate the pass rate(score) in percentage. For example 40% of students are passed.

Upvotes: 0

Views: 19201

Answers (2)

EddyAal59
EddyAal59

Reputation: 36

Have you tried this:

  • count the cells with the value passed,

  • divided that through the count of all cells

  • format outcome as percentage:

=countif(B2:B6; "passed")/ counta(B2:B6)

My example was with dutch excel but worked

Upvotes: 2

Ullas
Ullas

Reputation: 11556

Use COUNTIF to count the rows having the value 'PASS' and divide it by the total count. And use ##% format with TEXT function to make it to a percentage value.

Formula

=TEXT(COUNTIF(A1:An, "PASS") / COUNTA(A1:An), "##%")

Now could change the PASS value and the column range as per your requirement.

Demo

Upvotes: 0

Related Questions