Sum up grades

%3CLINGO-SUB%20id%3D%22lingo-sub-3357678%22%20slang%3D%22en-US%22%3ESum%20up%20grades%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357678%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20227%20students%20grades%20in%2017%20subjects.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20managed%20to%20sum%20up%20all%20the%20total%20of%20pupils%20in%206A%20but%20I%20want%20in%20percent%20how%20many%20that%20achieved%26nbsp%3B%3C%2FP%3E%3CP%3EA%2CB%2CC%2CD%20or%20E%20as%20a%20grade%20in%20each%20subject.%20I%20would%20like%20to%20be%20able%20to%20see%20how%20many%20percent%20of%20the%20pupils%20in%206A%20had%20A-E%20in%20Art%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20I%20have%20the%20wrong%20order%20or%20something%20because%20my%20formula%20wont%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUM.IF(Table1%3CSPAN%3E!A2%3AA227%2C%226A%22Table1!B2%3AB227%2C%20%22A%22%2C%22B%22%2C%22C%22%2C%22D%22%2C%22E%22)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanful%20for%20help!%20Jenny%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3357678%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357830%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20up%20grades%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357830%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387085%22%20target%3D%22_blank%22%3E%40JennyS71%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUM(COUNTIFS(Table1!A2%3AA227%2C%226A%22%2CTable1!B2%3AB227%2C%7B%22A%22%2C%22B%22%2C%22C%22%2C%22D%22%2C%22E%22%7D))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3357909%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20up%20grades%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3357909%22%20slang%3D%22en-US%22%3E%3CP%3EGot%20some%20amazing%20help!!!%3CBR%20%2F%3EThank%20you!!%26nbsp%3BQuadruple_Pawn%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi!

I have a spreadsheet with 227 students grades in 17 subjects. 

I have managed to sum up all the total of pupils in 6A but I want in percent how many that achieved 

A,B,C,D or E as a grade in each subject. I would like to be able to see how many percent of the pupils in 6A had A-E in Art etc. 

I think I have the wrong order or something because my formula wont work. 

=SUM.IF(Table1!A2:A227,"6A"Table1!B2:B227, "A","B","C","D","E")

Thanful for help! Jenny

1 Reply

Got some amazing help!!!
Thank you!! Quadruple_Pawn