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
Bookmarks