+ Reply to Thread
Results 1 to 7 of 7

Simple Q - how to calculate total commission made by each Sales Perosn

  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    London
    MS-Off Ver
    Starter 2010
    Posts
    3

    Simple Q - how to calculate total commission made by each Sales Perosn

    Hi everybody,

    I am coming across some difficulties in regards creating a formula. For demonstation purposes please see the example attached. The two formulas are aimed to:
    1. In the cell filled with yellow, calculate Mike's total commission (i.e. 400 as 100+200+100)
    2. In the cell filled with blue, calculate Mike's total units sold (i.e. 3)

    I appreciate any help guys. Thanks.

    edit: please ignore the attachement on the left.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by biscan; 06-11-2015 at 04:11 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,726

    Re: Simple Q - how to calculate total commission made by each Sales Perosn

    It would be easier to work on this if you would "Go Advanced" and upload the .xlsx file

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,306

    Re: Simple Q - how to calculate total commission made by each Sales Perosn

    Hi, welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

    having said that, take a lookm at using the SUMIF() function
    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

  4. #4
    Registered User
    Join Date
    06-11-2015
    Location
    London
    MS-Off Ver
    Starter 2010
    Posts
    3

    Re: Simple Q - how to calculate total commission made by each Sales Perosn

    Quote Originally Posted by JeteMc View Post
    It would be easier to work on this if you would "Go Advanced" and upload the .xlsx file
    I have just done so. Thanks.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,726

    Re: Simple Q - how to calculate total commission made by each Sales Perosn

    Here you go.

    Commission.xlsb

    I might also suggest that you add data validation to cell A9 so as to insure that a valid name is entered.
    Last edited by JeteMc; 06-11-2015 at 04:26 PM. Reason: Add a comment

  6. #6
    Registered User
    Join Date
    06-11-2015
    Location
    London
    MS-Off Ver
    Starter 2010
    Posts
    3

    Re: Simple Q - how to calculate total commission made by each Sales Perosn

    Quote Originally Posted by JeteMc View Post
    Here you go.

    Attachment 400558

    I might also suggest that you add data validation to cell A9 so as to insure that a valid name is entered.
    Amazing, thank you.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,726

    Re: Simple Q - how to calculate total commission made by each Sales Perosn

    Your welcome, and thank you for the feedback. Please mark the thread solved, hope you have a good day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate total sales adjustments for each sales person
    By Adama in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-02-2012, 06:26 PM
  2. Replies: 2
    Last Post: 05-24-2012, 05:49 AM
  3. Calculate Total Sales from a Database
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-03-2005, 08:30 AM
  4. [SOLVED] formula to calculate sales tax from total sales
    By Deanna in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-05-2005, 04:05 PM
  5. [SOLVED] calculate commission $ based on total sold and commission percent
    By blondeindenver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2005, 10:05 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