$3.$ In the range J$12$:K$17,$ Carla has created an area for analyzing the projects for specific types of services. She wants to analyze the sales of redesign projects because they have the highest billable amounts.

Create formulas to analyze this data as follows:

a$.$ In cell K$14,$ enter a formula using the COUNTIF function to count the number of redesign projects. Use the list of project codes $($range E$7$:E$16)$ as the range and the code for redesign services $($cell J$10)$ as the criteria in your formula.

b$.$ In cell K$15,$ enter a formula using the AVERAGEIF function to find the average billable amount for redesign projects. Use the list of project codes as the range, the code for redesign services as the criteria, and the discounted amounts $($range H$7$:H$16)$ as the range to average in your formula.

c$.$ In cell K$16,$ use the SUMIF function to find the total billable amount of redesign projects. Use the list of project codes as the range, the code for redesign services as the criteria, and the discounted amounts as the range to sum in your formula.