iI am having trouble getting the right formula . I was wondering if someone could help me with both these steps, the formula and the reasoning. Thanks

Rules Summarize the information by application type (Regular, Transfer). Write a formula in cell C15 that will determine the number of students that are transfer students. Write the formula so that it may be copied down the column to determine the number of Regular applicants. O Write a formula in cell 015 to calculate the Average Verbal scores for each type (T/R) of student application. Write the formula so that it may be copied down the column and across the row into cells D15:F16 to calculate the average for regular student's Verbal SAT and then for each student category Math SAT etc. A F 1 To help you complete this problem, we have provided the completed spreadsheet so you can check your results. Remember, you are graded for the formulas, not for the values, so don't enter the values directly in the cells. In later labs these check values may not always be provided. D Evaluation of Candidates 20% 40% 2 Weight in final score: 40% Verbal SAT Math SCI SAT Weighted SAT II score 3 Name Type R 680 580 636 4 Mary Keck 5 Alex Jones 670 690 T 770 640 686 6 Mark Wale T 700 730 670 700 R 590 780 660 694 7 Timoty Watkins 8 Scott Sharp 9 Brent Smith T 690 780 800 7201 710 730 742) 736) R 10 AVERAGE 701.67 731.67 665.00 699.00 11 MINIMUM 590.00 670.00 580.00 636.00 12 MAXIMUM 780.00 800.00 730.00 742.00 13 #of students AVG (verbal) AVG (math) AVG (SCI) 14 720.00 740.00 673.33 15 transfer students 16 regular students T R 3.00 3.00 683.33 723.33 656.67 C15 fx =AVERAGEIF(C4:09,"T",B4:39) A B D E F G H I J L M N O P 1 Evaluation of Candidates 20% 40% 2 Weight in final score: 40% Verbal SAT Math SAT SCI SAT Weighted Il score 3 Name Type 4 Mary Keck R 680 670 580 636 5 Alex Jones T 770 690 640 686 6 Mark Wale T 700 730 670 700 R 590 780 660 694 7 Timoty Watkins 8 Scott Sharp T 690 800 710 742 9 Brent Smith R 780 720 730 736 10 AVERAGE 701.67 731.67 665.00 699.00 11 MINIMUM 590.00 670.00 580.00 636.00 12 MAXIMUM 780.00 800.00 730.00 742.00 13 AVG (verbal) AVG (math) AVG (SCI) 14 #of students F 15 transfer students #DIV/0! #DIV/0! 16 regular students R #DIV/0! 17 18