| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sub-Total ?
I have a subtotal, that shows all the items in the subtotal. For example,
there are 4 salespeople with 10 to 30 accts each. So far, looks fine ...but... I would,like to just drill down a bit further and show just the salesperson name and the number of accrs they have. ss this possible ? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sub-Total ?
On Nov 23, 12:41 pm, Doug wrote:
I have a subtotal, that shows all the items in the subtotal. For example, there are 4 salespeople with 10 to 30 accts each. So far, looks fine ...but... I would,like to just drill down a bit further and show just the salesperson name and the number of accrs they have. ss this possible ? Thanks Try using a pivot table (data/pivot tables) or maybe even a simple SUMIF - function could do the trick. Cheers, Harold |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
