I am creating a spreadsheet that tracks our current staff across the country.
Is there a way to create a formula that counts from two different fields.

For example I want the total number of people if Column B reads "ATLANTA"
and column F reads "ACTIVE"

I was thinking I could use COUNTIF somehow....but can't quite figure it out