I am using the formula below to calculate the % of males (denoted as "M"
in the F column) scoring A*, A, B,.... U (contained in the H column) in
a list:

=SUMPRODUCT(--($F$48:$F$432="M"),--($H$48:$H$432="A*"))/
COUNTIF($F$48:$F$432,"?*")

In my test I find that if I have 4 entries - 3 male & 1 female it will
report that 25% of males scored A*, 25% scored A and 25% scored B,
instead of 33.3% for 3 boys only. It is including the female score when
doing the % calculation. How can I isolate the boys only scores ?


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

how about

=SUMPRODUCT((F48:F432="m")*(H48:H432="a*"))/SUMPRODUCT((F48:F432="M")*1)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=384082

That solution does not isolate the A grades from A*grades (A and A* are
read identically) and also gives blank scrores a reading of 100%.
Thanks anyways.


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

it seems to be working fine for me


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=384082

Thanks a lot Duane - tried it again and it works fine - gremlins.


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