I tried to come up with a title to explain what i'm trying to do but that didn't work. I'm working on a commission tracker for accessory sales in my retail locations. If the accessories sold exceed $100 for the day, 10% of total sold are put into a pot and split evenly between reps. Obviously you can tell the employees that work here on a day to day basis are sporadic. This is my data table. I've done this several ways now and keep running into issues. It seems like every way i try to do it, i can't figure out the logic behind it. It's like i have to check to see first if said name exists in the row..then count how many people worked that day and divide the amount by how many worked, and then multiple it by 10%. Not only that but i have to add all the rows of the month. Can this even be done in one cell for the output? If you need more info please ask..thanks!
The end result should yield John @ 10.48 commissions for 11/16 + 11/17.
<tbody>
</tbody>
The end result should yield John @ 10.48 commissions for 11/16 + 11/17.
Date | Amount | Emp 1 | Emp 2 | Emp 3 |
11/16/16 | $145.00 | John | Joe | Jerry |
11/17/16 | $113.00 | John | Joe | |
11/18/16 | $45.00 | John | Jerry | |
11/19/16 | $75.00 | Joe | Jacob |
<tbody>
</tbody>