I have a worksheet that has column I for first name and column J for last name that pulls the information from a different worksheet in the same workbook. Column K is for the total bonus paid to an associate to be calculated from data entered in Column B First Name, Column C Last Name, Column C Bonus Paid. The information is entered randomly. An associate may be listed several times in the list, but randomly or may not be listed at all.

This is the formula used, =sumifs(G12:G46,B12:b46,I12,C12:C46,J12) and it isn't working correctly for this problem.

Any assistance will be appreciated.