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

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