Surprise me with your Excel knowledge. I have a company that has four levels, (Sales Rep, Team Leader, Supervisor, Manager). Because it is a commission based company, Sales rep gets set commission (not percentage) from each sale. Team lead gets commission for their sale plus extra commission from their team sales reps. The supervisor gets smaller commission for every team lead and sales rep’s sales.
I need to have excel sheet that can calculate how many products were sold by each sales rep a…
