Depends on you data layout, certainly, but if your addresses are in rows
and the states are in their own column, strongly consider a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

In article ,
Richard wrote:

Hi,
I have rather large list of customer addresses and I want to know how many
are in each state. Then I would like to take that information and paste it on
another sheet. What function I would I use to that.