Thread: Sub-Total ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mohavv mohavv is offline
external usenet poster
 
Posts: 68
Default 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