I've attached an image that illustrates what I need to do.

I need to sum the population of each county (from multiple cells) and each city (from multiple cells), only if there are multiple counties and/ or cities.

excel-reference-sums.png

As you can see, Autauga has multiple cities and multiple zip codes. Prattville has multiple zip codes. I want to total the county population, based on the values included in each zip code, and the city populations based on the same criteria.

If this isn't possible, I may cry. The work I need to do, based on this example is ultra-extensive. I'm looking for shortcuts.