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

Any help much appreciated.


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

O24:

=SUM(--(MMULT((C24:C27="M")*ISNUMBER(MATCH(D24:M27,{"A"," B","C","D","E","F","G","U"},0)),TRANSPOSE(COLUMN(D 24:M27)*0+1))=5))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

P24:

=O24/COUNTIF(C24:C27,"M")

For '1 or more A*-U', change '=5' to '=1'.

Hope this helps!

Marie1uk Wrote:
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.


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

Domenic,

I've studied your replies to this thread with great interest. This use of
matrix math is very clever. Thank you for the lesson!

Lewis

Lewis Clark Wrote:
Domenic,

I've studied your replies to this thread with great interest. This use
of
matrix math is very clever. Thank you for the lesson!

Lewis

You're very welcome! I too find it very interesting. :)

Cheers!


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