Cindy,

Given that "Town" is in cell A1 and using this data as an example:

Town Names Members

Rochester Smith 4

Rochester Jones 3

St. Paul Smith 2

Minneapolis Franklin 4

Rochester Jamison 2

Minneapolis Jones 3

St. Paul Smith 2

St. Paul Jones 4

Rochester Barnes 3

Total Smith members = 8 (see formula below)

=SUMIF($B$2:$B$10,"Smith",$C$2:$C$10)

The number of Smith Families with 2 members = 2 (see formula below)

=SUMPRODUCT(($B$2:$B$10="Smith")*($C$2:$C$10=2))

The number of Smith families = 3 (see formula below)

=COUNTIF(B2:B10,"Smith")

You might want to look up the SUMPRODUCT, SUMIF, and COUNTIF functions in

Help for explanations.

What type of chart do you need to create?

----

Regards,

John Mansfield

http://www.pdbook.com
"Cindy" wrote:

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.