Please show what formula to use to get the

1)Sum of Red Team Sales divide by Sum of Blue Team Sales?

2) Percent bonus of all Red Team compared to Total Bonus?

Please take a look at the worksheet and show calculations.

Thank you

4 up as Basics Lecture. EMPLOYEE SALES BONUS TEAM BONUS $ Alfonso $ 250,000 5% RED Devin $ 96,500 2% RED This is item 6 Seher S 64,500 3% BLUE Michayla $ 124,000 6% RED Lim S 97,600 2% BLUE Tan S 37,500 0% BLUE TOTAL $ 670,100 Sum of Red Team Sales divided by Sum of Blue team Sales This is item 5 This is item Percent bonus of all Red team compared to Total Bonus 5 Find the Sum of Red Team sales then divided by Sum of Blue team sales to get the percentage of Red to Blue Sales. 6 Calculate the Bonus $ column for each employee as Sales * Bonus%. Sum the column. This is column F. 7 Find the Percent bonus of all Red team compared to Total Bonus 8 Resave the FILE again with the same name. EMPLOYEE SALES BONUS TEAM Alfonso $250.000 5% RED Devin $96,500 2% RED Seher $64.500 3% BLUE Michayla $124,000 6% RED Lim $97,600 2% BLUE Tan $37,500 0% BLUE TOTAL $670,100 Sum of Red Team Sales divide by Sum of Blue Team Sales Red $470,500 Blue $199,600 BONUS $ $12,500 $1,930 $1,935 $7.440 $1,952 $0 $25,757 ???? Percent bonus of all Red team compared to Total Bonus Red 13%