Percentage calculation on text columns

[Connor]

I have a sheet that represents exam candidates, their grades over 3
assignments with an average score, in the final COLUMN there is an
indication of whether they have passed or failed in the format "Pass"
"Fail". I need a formula that will count the overall group and give a
percentage of the group that has failed. Can anyone help?

 

[Roger Govier]

Hi Connor

One way
=COUNTIF(E2:E100,"Fail")/COUNTA(E2:E100)
Format the cell as Percentage.
I assumed headings in row 1, change ranges to suit.

Regards

Roger Govier

 

[Connor]

Thanks for your note, in your reply you said format cell as a
percentage, I am a complete novice to excel, would you please explain
how you do that.

Cheers

 

[Roger Govier]

Hi Connor

Either click the % button on your toolbar, then click on the cell with
the formula,
Or, Format>Cells>Number>Percent and select how many decimal places you
want to display.

Regards

Roger Govier