Data summation

I'm new to Excel so this may sound a bit simplistic. I have a list of organizational members with addresses, including states and zips. I want to know how many members reside in each state. How do I ...