Counting and Summarizing Data

[Phillycheese5]

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

[Domenic]

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
<[email protected]>,
Phillycheese5
<[email protected]> 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