Not sure what formulas would be used

Please advise formulas

Step 1: In the range G17:G116 calculate the transaction commission amount for each sales transaction. The transaction commission amount is the Purchase Amount times the % Commission. Only purchases that are eligible for commission should have a non-zero transaction commission amount. Purchases eligible for commissions will have a Y in column E. The % Commission varies depending on the agent making the sale.

Step 2: In the range C3:C12 calculate the Total Daily Commission for each agent and in cell C13 calculate the total daily commission for all the agents.

Step 3: In the range D3:D12 calculate the % of Total Commission Earned for each agent. The % of Total Commission is the Total Daily Commission for the agent divided by the Total Daily Commission.

Total Daily Commission % of Total Commision Earned Reference Table Code Name Yes No Y N. Commission Eligible Agents Jennings, Alfredo Black, Earlene Boyd, Roger Benjamin, Rosario Osborne, Sheree Miller, Leslie Conner, Rosella Newton, Maude Fox, Jeremy Mcclure, Bryan % Commission 4.00% 5.00% 6.00% 4.00% 5.00% 5.00% 1.00% 4.00% 2.00% 3.00% TOTAL DAILY COMMISSION: Average Daily Commission: Maximum Daily Commission: Agent with Max Daily Commission: Maximum Commission Bonus Total Bonus for 5.0% Calculation Transaction Commission Amount Gender M M Customer Name (Last, First) Baldwin, Sondra Harper, Alicia Porter, Roxanne Michael, Gina Battle, Gregory Atkinson, Joshua Ray, Madelyn Horton, Julio Bridges, Andy Mason, Tommy Holt, Allan Decker Lee Daily Sales Data Pull from All Pipe Inc Sales Management System State Agent Name (Last, First) Commission Eligible Purchase WV Jennings, Alfredo Y OH Jennings, Alfredo Black, Earlene Boyd, Roger Y Benjamin, Rosario Osborne, Sheree Miller, Leslie Conner, Rosella Newton, Maude Fox, Jeremy Osborne, Sheree Beniamin Rosario Customer Purchase Amount $133.00 $6.00 $306.00 $380.00 $85.00 $185.00 $342.00 $328.00 $500.00 $165.00 $85.00 $5.00 M OH Total Daily Commission % of Total Commision Earned Reference Table Code Name Yes No Y N. Commission Eligible Agents Jennings, Alfredo Black, Earlene Boyd, Roger Benjamin, Rosario Osborne, Sheree Miller, Leslie Conner, Rosella Newton, Maude Fox, Jeremy Mcclure, Bryan % Commission 4.00% 5.00% 6.00% 4.00% 5.00% 5.00% 1.00% 4.00% 2.00% 3.00% TOTAL DAILY COMMISSION: Average Daily Commission: Maximum Daily Commission: Agent with Max Daily Commission: Maximum Commission Bonus Total Bonus for 5.0% Calculation Transaction Commission Amount Gender M M Customer Name (Last, First) Baldwin, Sondra Harper, Alicia Porter, Roxanne Michael, Gina Battle, Gregory Atkinson, Joshua Ray, Madelyn Horton, Julio Bridges, Andy Mason, Tommy Holt, Allan Decker Lee Daily Sales Data Pull from All Pipe Inc Sales Management System State Agent Name (Last, First) Commission Eligible Purchase WV Jennings, Alfredo Y OH Jennings, Alfredo Black, Earlene Boyd, Roger Y Benjamin, Rosario Osborne, Sheree Miller, Leslie Conner, Rosella Newton, Maude Fox, Jeremy Osborne, Sheree Beniamin Rosario Customer Purchase Amount $133.00 $6.00 $306.00 $380.00 $85.00 $185.00 $342.00 $328.00 $500.00 $165.00 $85.00 $5.00 M OH