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.

Transcribed Image Text:

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

Answer rating: 100% (QA)

To achieve the desired summaries in cells K2 L2 and M2 you can use the following formulas In cell K2 ... View the full answer