Hi,
I hope someone can help me with this problem because I can't even figure out where to start.
I have a workbook with 2 sheets. A wages sheet and a commissions sheet. The commissions are withheld for 2 weeks so what I am trying to do is put together a Gross Salary + Commissions for that pay period.
So if the pay period (for wages only) is 5/19/2013 to 6/1/13 I need to add in the commissions that were earned during the previous pay period (or date range) which was 5/5/13 to 5/18/13.
For each day during that period (5/5/13 to 5/18/13), there are multiple commissions earned.
I am trying to create a formula that will for example, on the wages sheet, look at the date on the 19th, find or search through the dates on the commissions sheet until it finds a date 14 days prior and "forall" occurrences of commissions earned on that date(which would be the 5th) add them together and pull them in to the Gross pay column on the wages sheet, also adding in the wages earned on the 19th.
So gross pay would equal wages earned on the 19th+all commissions earned on the 5th.
I hope this is making sense, because I'm confusing myself!!
I have attached the workbook that I am utilizing in the hopes that someone will understand what I am trying to do here. Thanks!
Pay and Barrel Commission.xlsx
Bookmarks