Counting and Summarizing Data

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

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.22o9nb_1139001602.1061@excelforum-nospam.com>,
Phillycheese5
<Phillycheese5.22o9nb_1139001602.1061@excelforum-nospam.com> 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