Counting the number of same value cells
 

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,

Counting the number of same value cells
 

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.