Camille also wants to summarize the number of discounted products by product fype and calcule their total and average discounted prices.

In cell K$2,$ enter a formula using the COUNTIF function that counts the number of Carrier products, using Discounts$[$Product Type$]$ as the range and cell J$2$ as the criteria. Fill the range $K3$:$K9$ with the formula in cell $K2.$

In cell L$2,$ enter a formula using the SUMIF function that totals the discount prices for Carrier products, using Discounts$[$Product Type$]$ as the range, cell J$2$ as the criteria, and Discounts $[$Discount Price$]$ as the sum$\_$range. Fill the range $L3$:$L9$ with the formula in cell $L2.$

In cell M$2,$ enter a formula using the AVERAGEIF function that averages the discount prices for Carrier products, using Discounts$[$Product Type$]$ as the range, cell J$2$ as the criteria, and Create a formula using a function.