Countif multiple conditions

  • Thread starter Thread starter dinkalley
  • Start date Start date
D

dinkalley

Here's my question:

I have a column that shows a score. I have another column that
indicates gender.

I would like to count the number of times the score is above 9, when
the gender is F. How do I do that?

Thanks,

Mary
 
If the scores are in A1:A100 and the genders in B1:B100;
use =SUMPRODUCT(--(A1:A100>9),--(B1:B100="F"))
Bernard
 
Back
Top