Percentage calculation on text columns

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?

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?
>
>
>
>

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

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



Connor wrote:

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