| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table (totals) question ??
I want to build a pivot table that will give me totals...like this...
A B MAJOR ZIP Accounting 10002 Accounting 10003 Accounting 10003 Accounting 10005 Biology 10005 Biology 10005 Biology 10007 So I want to build a total that will look something like this...will tell me how many accounting people are in zip 10003 etc. MAJOR ZIP TOTAL Accounting 10003 2 10002 1 10005 1 Biology 10005 2 10007 1 How would I build this total? I did a =COUNT(B1) but this did not work... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table totals | Excel Discussion (Misc queries) | |||
| Pivot table totals | Excel Discussion (Misc queries) | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
| pivot table question about count and totals | Excel Discussion (Misc queries) | |||
| Pivot Table - Sub totals | Excel Discussion (Misc queries) | |||
Threaded Mode
