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
Bookmarks