Results 1 to 8 of 8

Help with subtotaling

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2006
    Location
    Massachusetts
    MS-Off Ver
    Version 2402 Build 16.0.17328.20124)
    Posts
    61

    Help with subtotaling

    Hi,
    On the attached worksheet, I have subtotaled the Mkt Reps in order to count the number of referrals they have provided in a month.
    I also sorted by the Mkt Rep to alphabetise the referral source.
    What I am also trying to do, is get count of each referral source associated with each Mkt Rep.
    So for instance, (using attached wkst)

    Mktg Rep = Burns
    Total Referrals =39
    # Referrals from Aberjona for Burns =?
    # Referrals from Berenson = ?
    I guess I am trying to subtotal a subtotal...

    Any ideas on how to achieve what I am looking for?
    Much appreciated.
    Attached Files Attached Files
    Last edited by Janie; 07-26-2013 at 04:30 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. subtotaling
    By loner2003 in forum Excel General
    Replies: 4
    Last Post: 10-05-2011, 04:33 PM
  2. Subtotaling
    By loner2003 in forum Excel General
    Replies: 0
    Last Post: 03-04-2011, 10:27 AM
  3. Subtotaling
    By iui in forum Excel General
    Replies: 1
    Last Post: 08-10-2010, 10:52 AM
  4. subtotaling
    By oneilltm in forum Excel General
    Replies: 0
    Last Post: 09-21-2006, 06:40 PM
  5. subtotaling
    By oneilltm in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-21-2006, 06:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1