The easiest way is to use a PivotTable. Otherwise, use the "Advanced
Filter' to your range of interest and check 'Unique records only'. Then
use COUNTIF...

Hope this helps!

In article
,
Phillycheese5
wrote:

I have a customer list and I'd like to know how many are from each
state. Is there a function that can generate a listing of each state
and a count for each?

Thanks,
Phillycheese