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?


--
Connor
------------------------------------------------------------------------
Connor's Profile: http://www.excelforum.com/member.php...o&userid=27970
View this thread: http://www.excelforum.com/showthread...hreadid=474704

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


--
Connor
------------------------------------------------------------------------
Connor's Profile: http://www.excelforum.com/member.php...o&userid=27970
View this thread: http://www.excelforum.com/showthread...hreadid=474704

Hi Connor

Either click the % button on your toolbar, then click on the cell with
the formula,
Or, FormatCellsNumberPercent 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