Counting and Summarizing Data

P

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
 
D

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!

Phillycheese5
 
Top