GCSE result analysis

I am trying to calculate the number of GCSE A-C that my students have. The data is in the format of a list comprising of columns for name,subject and grade. A result for a subject will be per row eg.
Fred, Biology, A
Fred, English, D
Fred, Maths,C
Mary, English, C
Mary, French, B

Any suggestion how to calculate the number of GCSEs per student and maybe if the have maths/englisg.

Thanks.

Hi,
The actual grades are irrelevant in terms of pass/fails but A/B/C are classed as passes and D/E/F would be classed as not so good. It is usual for such counts to be done by hand as most institutes have few numbers. I have approx. 10 years of data to process for approx. 3000 students each with approx. 8 results ... in the region of 240,000 results to process and see if there is a trend forming etc.

The information I am attempting to process has been given to me as a single row per exam result. I need to calculate the number of [A/B/C] grades and [D/E/F] grades that a student has. I have managed to do this with countIFs which has provided me with the results against each row. eg. Calculating the number of A/B/C's that a student has column where Fred has 3 A/B/C and Joe has 1 A/B/C.

FRED Maths A 1
FRED English A 2
Joe Maths C 1
FRED French B 3
Joe English D 1

The problem is that now I need to remove rows for the same student as I am not interested in the actual subjects just the totals. There is an unknown number of names and results. What I then would like to produce is the number of students with [less than 5 GCSEs], [5 or more GCSEs], [5 or more GCSEs with English], [5 or more GCSEs with Maths], [5 or more GCSEs with Maths & English], and so on. I need to do this analysis for approx. 10 years of results for several sites to see if there is a pattern etc. The alternative could be VBA code? Any suggestion etc - what is the best/quickest method.