View original (French)

Calculate failure percentage with Excel

Solved
Medic911 Posted messages 10 Status Member -  
Medic911 Posted messages 10 Status Member -
Hello,

In one column, I have the results of 25 students. I want to get the percentage of students who scored below 60.

Thank you

Configuration: Windows 7 / Internet Explorer 7.0

3 answers

  1.
    Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
     
    Hello,

    for example, if your 25 results are in column A from A1 to A25, in the cell where you want this percentage you put the formula:
    =COUNTIF(A1:A25,"<60")/25
    so the number of grades below 60 divided by the total number of grades

    Have a nice day
    --
    Every problem has a solution... you just need to be persistent.
    5
  2. smartway14 Posted messages 857 Registration date   Status Member Last intervention   186
     
    Hello;
    =(COUNTIF(A1:A25,"<60")*100)/25
    1
  3. Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
     
    Smartway14 is exactly the same as my formula
    --
    Every problem has a solution...you just need to be persistent.
    0
    1. Medic911 Posted messages 10 Status Member 1
       
      Thank you, it works.
      0