Ok thanks,

I have decided to include a by gender 5 or more A*-U & 1 or more A*-U
analysis too and set up a test area of 4 pupils marks with data:

In A24 will be their first name, B24 will be their surname, C24 their
gender (M=male, F=Female) and from D24 - M24 will be a list of their
grades (A*- U). D24 - M27 will hold the test grades.

I need it to calculate a BOYS & GIRLS ONLY analysis of pupils getting
5 or more A*-U and 1 or more A*-U (number of boys / girls as well as a
percentage of boys / girls).

Thanks in advance,

Marie.


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