Matching & Counting Problem

[stevejpearson]

Dear all,

I am hoping there is a simpl (ish) way to achieve the following:

I have a list of pupil levels (3,4,5,6) in one column and other columns showing if these pupils are currently on track to achieve 5 grades including english and maths in their exams and also to show what grade they are currently going to achieve in their english and maths exams.

I am trying to find a way to count how many pupils that achieved a level 3 (or 4 or 5 or 6) achieved a C grade or higher in english and how many of the level 5 students achieved 5 a*-c grades including english and maths.

Realise this may not be entirely clear so have placed the following file for download:

http://www.box.net/shared/outafr74r8

 

[xld]

Try

=SUMPRODUCT(($A$3:$A$204=6)*($B$3:$B$204="Y")*($D$3:$D$204={"A","B ","C"}))

etc.

 

[Norie]

I've downloaded that file and even after a bit of reformatting I can't understand it.

You mention pupil levels but I don't see that anywhere - is that perhaps the ROUNDED AV(erage?) column?

Also does 5 a*-c grades mean the pupil has received 5 results between the grades a* and -c?

 

[stevejpearson]

<!-- / message --><!-- sig -->Sorry you are right I didnt make it clear, but you are correct the pupil levels is the rounded average column and the 5a*-c grades does mean that they achieved 5 results between a*-c

Hope this makes more sense now.