View Single Post
  #3   Report Post  
Old January 13th 05, 12:09 AM
John Mansfield
 
Posts: n/a
Default

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.