Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |