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


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=508312

Counting and Summarizing Data
 

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