3

I have a table like below:

Q: How can I count all Female Undergraduate or Male Diploma ? enter image description here

3

Place these formulas somewhere

=COUNTIFS(B2:B25,"Male",C2:C25,"Diploma")
=COUNTIFS(B2:B25,"Female",C2:C25,"Undergraduate")
|improve this answer|||||
3

For multi-conditional counting use COUNTIFS function, e.g. to count Female Undergraduates

=COUNTIFS(B:B,"Female",C:C,"Undergraduate")

COUNTIFS requires Excel 2007 or later version

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.