Calculating multiple commissions

Hi. I'm looking to get a formula to calculate an employee's commission. On worksheet1 there is the employee code (Col. B) and amount of commission (Col. H) but employees are listed multiple times with multiple commissions and need it to add all together. On worksheet2 I'm trying to link the employee code (Col. C) with worksheet2 employee code (Col. B). I did a vlookup but it's finding one commission and stopping there.

Example: Worksheet 2
Col. A Col. B Col. H
John Smith 0123456 $5.00
John Smitth 0123456 $10.00


Help!

Here is a PDF of an example. For the expected commissions, it goes by tenure in months. Hope this helps because I haven't been able to figure it out!

Hard to tell what you are talking about without seeing the excel workbook
...but try adding a pivot table to sum up the data

Here is a XLXS. I figured the PDF would be sufficient. There isn't a lot of data in the workbook but it gets the point across. I know I can do a VLOOKUP but the problem lies in multiple submissions of employee numbers and I need all the submission's commissions to be calculated.

Neither of those worked. It's giving me all "0" for the actual commission and "N/A" for the expected. Let me further explain the spreadsheets, I'm sorry but I can't share the information and in order for me to actually make a more in depth example, it would take quite a long time.

Actual Commissions is raw data. There is 5043 columns with every employee name, employee number, office, social, employee address, amount of commissions. There are no formulas in this worksheet.

Agent Tenure is raw data as well. There are about 800 columns with every employees (duplicates have been deleted and this only contains "Active" employees). Is this making sense? I don't know how else to explain, show and get to a solution.

Basically, for actual commissions, I would use a VLOOKUP but there are multiple of the same employee numbers in the worksheet with different commissions. I want the formula to compare and find employee numbers from the employee tenure worksheet and the actual commissions worksheet and then add all the commissions for the employee number.

I did the actual commission like this....

Formula:

Please Login or Register  to view this content.

Is that what you mean?

With these formulas, you're specifying each column ($B$3:$B$9), my data is much bigger than this, this was just an example. So do I just put in the first and last row number in place of the "3" and "9" for the formula B and G column?

If the data starts at row 3 in column B and goes down to row 5043 then define the range as $B$3:$B$5034

I added to your example, think its what you mean. You just need to extend the ranges down to however many rows it goes down to and copy and paste the formula down the list.

Ugh! It's still not working. I feel like what I want is pretty simple but for some reason I can't figure it out! All I want is to match all employee numbers from two worksheets and add the corresponding commissions.

Look on what I attached on my above post, the formula in cell D3 on the Employee Tenure sheet is finding Judy Right by employee number on the Actual Commissions sheet and summing the values from column G. Its there twice in the list and the values are $21.00 & $8.25. The total of 29.25 is returned. This is how I understand your question from the example you have provided.

With regards to the expected commissions, I don't really understand your layout on that sheet. Maybe if you could make the example more clear it would help

The actual commissions worked!! Thanks so much!