Column A is Town, Column B is names, Column C is how many in each household.

How can Excel add & tell me how many Smiths in each town and, if possible,

how many Smith families with 2 people in each town. Then I want to chart the

info. How many of each family name by town.

## Bookmarks