| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal or count
Zip City
55901 Mytown 55901 Mytown, 55906 Yourtown 55906 Yourtown, 55906 Yourtown, I subtotal on Zip code and use Count function This gives a new column with subtotal in this format: 55901 Count 2 55906 Count 3 My objective is to subtotal on zip code but wish to see the label be the 'City' i.e Mytown Count 2, Yourtown, Count 3 Any suggestions would be much appreciated. I am using MS Excel 2000. Tosh. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I do a count subtotal AND a sum subtotal on the same row? | Excel Discussion (Misc queries) | |||
| Subtotal count not working | Excel Discussion (Misc queries) | |||
| how to put the subtotal of the sum and count in one spreadhseet? | Excel Worksheet Functions | |||
| how to sum and count in subtotal | Excel Discussion (Misc queries) | |||
| SUBTOTAL and then count with criteria | Excel Worksheet Functions | |||
Threaded Mode
