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 wrote:

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?