% error calculating grades

  • Thread starter Thread starter Marie1uk
  • Start date Start date
M

Marie1uk

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 ?
 
That solution does not isolate the A grades from A*grades (A and A* ar
read identically) and also gives blank scrores a reading of 100%
Thanks anyways
 
Back
Top