1. Camille also wants to summarize the number of discounted products by product type and calculate their total and average discounted prices. In cell K2, enter a formula using the COUNTIF function that counts the number of Carrier products, using Discounts[Product Type] as the range and cell J2 as the criteria. Fill the range K3:K9 with the formula in cell K2. In cell L2, enter a formula using the SUMIF function that totals the discount prices for Carrier products, using Discounts=sumif[Product Type] as the range, cell J2 as the criteria, and Discounts[Discount Price] as the sum_range. Fill the range L3:L9 with the formula in cell L2. In cell M2, enter a formula using the AVERAGEIF function that averages the discount prices for Carrier products, using Discounts[Product Type] as the range, cell J2 as the criteria, and Discounts[Discount Price] as the average_range. Fill the range M3:M9 with the formula in cell M2.

Product ID Product Name Product Type Pet Type Discount Start Current Price Discount Price Promo Ad Product Type Number Discounted Total Price $ 1 C-34823 C-51386 E-52387 E-52701 E-55032 F-36970 F-39012 F-39776 H-13458 L-40117 L-40688 L-74119 T-22854 T-22876 Y-11842 Total Cold-weather coat Clothing Airline-approved pet carrier Carrier Expandable bird cage Exercise Tunnel and tent for indoor cats Exercise Silent exercise wheel Exercise Decorative litter box enclosure Furniture Elevated bed, large Furniture 2-story cat condo Furniture Serene 8-month flea collar Health Retractable leash, reflective Training Retractable hands-free leash Training Training collar with remote control Training Grain-free crunchy bits Treat Feline Bites, soft chewables Treat Classic treat toy Toy Dog Cat Bird Cat Small animal Cat Dog Cat Dog 3 3 1 3 11/12/2021 11/12/2021 11/12/2021 11/12/2021 11/12/2021 11/19/2021 11/19/2021 11/19/2021 11/19/2021 11/19/2021 11/19/2021 11/26/2021 11/26/2021 11/26/2021 11/26/2021 $44.95 $32.99 $45.95 $72.39 $30.59 $149.49 $31.99 $59.99 $15.99 $21.95 $16.99 $39.99 $8.99 $42.70 $31.34 $43.65 $68.77 $29.06 $142.02 $30.39 $56.99 $15.19 $20.85 $16.14 $37.99 Carrier Clothing Exercise Furniture Health Training Treat Toy TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE FALSE FALSE FALSE TRUE FALSE FALSE FALSE 15 2 1 Average Price $ 31 $ 43 $ 47 $ 76 $ 15 $ 25 $ 6 $ 6 Dog Dog Dog Cat Cat Dog $8.54 $4.49 $5.95 $582.69 $4.27 $5.65 $553.56