Google Sheets formula to count cells if the city/town is in Hartford County, CT

hartford_county_count.txt

=ArrayFormula(SUM(COUNTIF(G2:G70,{"Addison", "Alsop Corner", "Avon", "Avon Park North", "Avon Park South", "Bahre Corner", "Bell Air", "Bellin Terrace", "Bensted Corner", "Berlin", "Birchwood", "Bishop's Corner", "Bloomfield", "Blue Hills", "Brainerd Park", "Breakneck", "Bristol", "Broad Acres", "Broad Brook", "Brookhaven Village", "Buckingham", "Buckland", "Bull Run Corner", "Burlington", "Burnham", "Burnside", "Canton", "Canton Center", "Canton Valley", "Carroll Corners", "Case Corner", "Chatsworth Village", "Cherry Park", "Children's Village of the Hartford Orphan Asylum", "Coachlight Village", "Collinsville", "Colonial Mobile Home Park", "Corbin Heights Housing", "Cottage Farms", "Cottage Grove", "Cotton Hollow", "Crowleys Corner", "Dutch Point Colony", "East Berlin", "East Bristol", "East Farmington Heights", "East Glastonbury", "East Granby", "East Hartford", "East Hartford Gardens", "East Hartland", "East Plymouth", "East Side", "East Windsor Hill", "Ebbs Corner", "Edgewood", "Elm Hill", "Elmwood", "Elmwood Acres", "Enfield", "Farmingdale Village", "Farmington", "Farmington Station", "Farnhams", "Fernridge Place", "Firetown", "Five Points", "Flax Hill Elderly Housing", "Floydville", "Foote Corners", "Forbes Village", "Forest Village", "Forestville", "Four Corners", "Glastonbury", "Glastonbury Center", "Glenwood Homes", "Goodrichville", "Granbrook Park", "Granby", "Green Manor Village", "Griswoldville", "Halladay Corner", "Hampsted", "Hartford", "Hartland", "Hathewood", "Hayden", "Hazardville", "Highland Park", "Higley Village", "Hilliardville", "Hockanum", "Hopewell", "Hoskins", "Huckleberry Hills Trails", "Hungary", "Keeney Park", "Kensington", "Kew Gardens", "Kings Corner", "Lamson Corner", "Liberty Mobile Home Park", "Lovely Street", "Lydallville", "Manchester", "Manchester Green", "Marion", "Marlborough", "Mayberry Village", "McKinley Park", "Meadowgate", "Mechanicsville", "Melrose", "Mill Pond Village", "Milldale", "Moravia Woods", "Mount Pleasant Housing", "New Britain", "Newington", "Newington Junction", "North Bloomfield", "North Canton", "North End", "North Granby", "North Hollow", "North Thompsonville", "Oakland", "Oakland Gardens", "Oakland Hills", "Old Avon Village", "Orford Village", "Oxford Village", "Parkville", "Pegville", "Pequabuck", "Pine Hill", "Pinnacle Heights Housing", "Plainville", "Plantsville", "Poquonock", "Pratts Corner", "Prospect Heights", "Rainbow", "Rising Corner", "River Glen", "Rivermead Mobile Home Park", "Rocky Hill", "Roland Heights", "Salmon Brook", "Saybrooke Village", "Scantic", "Scitico", "Shaker Pines", "Sherwood Manor", "Silvermine Acres", "Simsbury", "Smith Tower Housing", "South Glastonbury", "South Side Park", "South Wethersfield", "South Windsor", "Southington", "Southwood Acres", "Spoonville", "Spring Village", "Stillmans Corner", "Stowe Village Housing Project", "Suffield", "Suffield Depot", "Tariffville", "Tariffville Center", "Taylor Town", "Terramuggus", "The Gables", "Thompsonville", "Thralltown", "Timber Village", "Tootin' Hills", "Tudor Village", "Turkey Hill", "Unionville", "Victory Heights", "Wapping", "Wapping Mews Elderly Housing", "Warehouse Point", "Weatogue", "Welles Village", "Wells Quarter Village", "West Avon", "West District", "West Granby", "West Hartford", "West Hartland", "West Hill", "West Simsbury", "West Suffield", "Westfield Heights", "Westmoor Park", "Wethersfield", "Whigville", "Whitings Corner", "Wilson", "Windmill Springs", "Windsor", "Windsor Locks", "Windsorville", "Wintonbury Hill", "Woodland"})))