Counting the number of same value cells

[Richard]

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.

Thanks,

 

[JE McGimpsey]

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