Countif multiple conditions

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
 
B

Bernard Liengme

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Countif - Sumproduct 3
COUNTIF or SUMPRODUCT with Mulitple Criteria 3
Lookup multiple cell values and place contents in a single cell 3
Conditional Formula, counting one criteria in a range based on ano 3
Countif 3
Average with criteria for adjacent cells ? 1
COUNTIF: everything in a row larger than zero over multiple worksh 1

Top