Read Help for Pivot Table
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Cindy" wrote in message
...
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.