+ Reply to Thread
Results 1 to 2 of 2

Formula to add sales figures together when there are multiple entries for each sales rep

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Formula to add sales figures together when there are multiple entries for each sales rep

    Hello!

    thank you all for your assistance with this.

    I am a sales manager and I have a Spread Sheet that keeps track of every sale my sales team makes. I need to find a way to automatically add each sales reps results automatically. I currently use the sort feature to isolate a particular sales rep and simply highlight the column with the sales $$ figures and look at the total in the bottom right of the screen (along with Average and count)

    I need a way to have these sales figures for each of my reps automatically calculated.

    My spreadsheet is set up the following way:

    A B C
    1 Rep Sales $$ School Name
    2 Joe $3,584.34 Lincoln Elementary
    3 Josh $5,684.44 Adams Elem
    4 Mary $2,447.87 Jefferson Elem
    5 Joe $5,667.88 Stevens Elem
    6 Jill $3,546.77 Ball Elem
    7 Josh $7,584.89 Grove Elem
    8 Joe $1,243.55 Grandview Elem
    9 Jill $7,896.22 Valley Elem

    ECT............

    I would like to see on the spreadsheet the total cumulative sales for each rep as the data is entered into the spreadsheet. I imagine this is possible, but I have no clue how to do this.

    Thank you for your help!!

    Ron D.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Formula to add sales figures together when there are multiple entries for each sales r

    try using this formula.....

    =sumif(A:C,"Joe",B:B)

    you can modify the A:C and B:B to just the range you need - in your example that would be
    sumif(A1:C9,"Joe",B1:B9)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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