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
|