Grades range from A* (highest) to U (lowest), but U's are not needed as
part of the analysis I need, just A*, A, B, C,D,E,F & G. Pupils who
fail to turn up for the exam are classed as Abs on the spreadsheet,
where Abs will replace the 'grade' for that exam. The formula then
needs to count how many Abs marks there were for all pupils (305 ish)
and express them as a % of all grades possible, so:

305 pupils take for example 8 exams each = 2420 grades. 20 exams are
missed by pupils failing to turn up and are classed as Abs on the
spreadsheet so it needs to be able to count those 20 cells with abs in
as express it as a % of all grades possible, ie 20/2040. Hope this
makes sense :)


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