Sorting data from 2 columns

[jwsemus3]

So we have a large data set with information from of about 150 people (age, sex, nationality, etc.) We want to count how may people are female AND from the United States. There is a column in the sheet with "Male" or "Female" and another column with the name of the country. How can we create a formula that counts how many of these people are Female and from the United States?

 

[Joe4]

Welcome to the Board!

Use the COUNTIFS formula, which can count records on multiple conditions.
See: https://www.techonthenet.com/excel/formulas/countifs.php

 

[mumps]

Assuming gender is in column A and country is in column B, place this formula in any desired cell:
=COUNTIFS(A2:A20,"Female",B2:B20,"US")
Change the ranges to suit your needs.