Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|