So, taking the easy way out came around to bite me in the butt. I had someone help me with the formulas for this excel sheet, now I need to make a change, and have no idea how to do it.
Hopefully the sheet is pretty self explanatory but basically I need to subtract the 1099 column for each month (H24:H200) from the commission totals for each month (F2:F13) and place that value in a new column under TOTAL NET COMMISSIONS G2:G13
For example, in October, there were two 1099 entries ($1,467.00 & $1,500.00)
I need to add up the total 1099 value for each month and then subtract it from the month's total commission.
Geez... I am rambling. If anyone has a clue as to what I need please help, or point me in the right direction! Thank you so much in advance! File attached.
Attachment 435517
Bookmarks