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