Hi Marie!

Assuming that D2:O10 contains your grades...

For the number of pupils scoring 5 grades or higheer (A*- C):

Q1:

=SUM(--(MMULT((D2:O10="A*")+(D2:O10="A")+(D2:O10="B")+(D2 :O10="C"),TRANSPOSE(COLUMN(D2:O10)*0+1))=5))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. For the
percentage of pupils scoring 5 grades or higher (A*- C):

R1:

=Q1/COUNTA(A2:A10)

Adjust the range and criteria accordingly. As far as the number and
percentage of pupils absent, can you provide more information?

Marie1uk Wrote:
Hi there,

I am a teacher and need to analyse my results for review and target
setting purposes.

I need the spreadsheet to generate results for the following:

Number of pupils scoring 5 grades (or higher) A* - C
% of pupils scoring 5 grades (or higher) A* - C
Number of pupils scoring 5 grades (or higher) A* - G
% of pupils scoring 5 grades (or higher) A* - G
Number of pupils scoring 1 (or higher) grade A*-G
% of pupils scoring 1 grade (or higher) grade A* - G
Number & % of pupils who were absent

In column A will be the pupil's first name, column B will be their
surname, C their gender and in columns D - O will be where I will input
their grades (not all cells D - O will necessarily be used). Using this
format what is the best formula for obtaining the necessary results?

Many thanks for your consideration,

Marie.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=384303