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
