You can do this using a variation of SUMPRODUCT(). You'll need to
expand the ranges to reflect your application, but try this:
=SUMPRODUCT(--(B1:B10="ATLANTA"),--(F1:F10="ACTIVE"))

Note that spelling matters! ATLANT A is different from ATLANTA and
even a trailing or leading blank space will skew your results. Hope
this does it for you!