Closed Thread
Results 1 to 5 of 5

Need formula to calculate commissions for employees based on the month earned on 2 sheets

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Need formula to calculate commissions for employees based on the month earned on 2 sheets

    Having some problems figuring this out. Basically when I enter an emp ID, Commission amount and date on one sheet, I want it to calculate the total commissions to the correct employee based on the month on sheet2. Please help.

    Sheet1
    A1:A20 = Employee ID number - 1, 2, 3 or 4
    B1:B20 = Commission $ amount varied
    C1:C20 = Date in the following format 12/28, etc.

    Sheet2
    A1:A12 = Months January – December
    B1:B12 = formula to calculate commissions for employee 1 based on corresponding month
    C1:C12 = formula to calculate commissions for employee 2 based on corresponding month
    D1:D12 = formula to calculate commissions for employee 3 based on corresponding month
    E1:E12 = formula to calculate commissions for employee 4 based on corresponding month

  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,917

    Re: Need formula to calculate commissions for employees based on the month earned on 2 she

    It might help if you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    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

  3. #3
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Re: Need formula to calculate commissions for employees based on the month earned on 2 she

    Please see attached worksheet

    Having some problems figuring this out. Basically when I enter an emp ID, Commission amount and date on one sheet, I want it to calculate the total commissions to the correct employee based on the month on sheet2. Please help.

    Sheet1
    B2:B21 = Employee ID number - 1, 2, 3 or 4
    C2:C21 = Commission $ amount varied
    D2:D21 = Date in the following format 12/28, etc.

    Sheet2
    A2:A13 = Months January – December
    B2:B13 = formula to calculate commissions for employee 1 based on corresponding month
    C2:C13 = formula to calculate commissions for employee 2 based on corresponding month
    D2:D13 = formula to calculate commissions for employee 3 based on corresponding month
    E2:E13 = formula to calculate commissions for employee 4 based on corresponding month
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Need formula to calculate commissions for employees based on the month earned on 2 she

    Is this not the same identical thread as
    http://www.excelforum.com/excel-form...61#post3389861
    ?

    I did pose the question there though why not use a pivot table as shown in sheet 3 here. I only know how to do a manual refresh when data changes someone more advanced may be able to set up an automatic refresh on data change, not sure if possible though.

    Example.xlsx
    Last edited by Busclas; 09-01-2013 at 05:43 PM. Reason: Posting response posted on other thread.

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need formula to calculate commissions for employees based on the month earned on 2 she

    Thanks Busclas.

    excelteam777,

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 06-20-2013, 02:31 PM
  2. Replies: 1
    Last Post: 02-02-2013, 02:28 PM
  3. [SOLVED] How can I calculate commissions that are not percentage based?
    By Sean in forum Excel General
    Replies: 3
    Last Post: 03-31-2006, 03:10 PM
  4. [SOLVED] Help With Formula To Calculate Commissions
    By Smonczka in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-04-2005, 11:50 AM
  5. Replies: 2
    Last Post: 03-15-2005, 04:06 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