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

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.