| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot and count question.
Hello,
I have the following pivot table with Row column being State Name and county Name with Population as Data. How would I be able to count the number of county name in each state? My main grid has the name of each of these members with the state and county. State Name County Name Population New York Kings 1.1 mil Queens 1.2 mil Bronx 2.1 mil Richmond .5 mil New York Total 4.9 mil New Jersey Bergen 3.5 mil Elizabeth .58 mil New Jersey Total 4.08 mil Texas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT QUESTION | Excel Discussion (Misc queries) | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
| I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
| Day Count Question | Excel Discussion (Misc queries) | |||
| pivot table question about count and totals | Excel Discussion (Misc queries) | |||
Threaded Mode
