student tracking % English and maths.xlsHi there, I have an issue with a tracking sheet for looking at students grades, there are two columns (arrays?) both equal in length, which contain the students grades for subjects English and maths. I want to get excel to look down each column and count the number of matches when both columns meet certain criteria. ie the grades are in the form of A+,A,A-,B+,B,B-,..... im looking to count all the matches of A+ to C-, and any combination there of for each row. sometimes a student might be above a C- in one subject but not the other. (this is what im trying to identify as a target group, by calculating how many students have c- or above in both subjects and therefore the students left are who i target) i hope this makes sense?
I have added an attachment below to show what im working on. in cell O103 i would like it to return the percentage of students who are achieving C- or better in both English and maths. I am assuming its just a matter of formatting the cell for percentage once the formula is correct.
Can anyone help??
Cheers Paul
Bookmarks