Sub-Total ?

[Doug]

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

 

[mohavv]

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