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

1. ## 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. ## 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

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

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

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

5. ## 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.

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

#### 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