9 In cell N6, determine the total number of times the criteria "Rewards" (cell M6) is used as the payment method (in F6:F32). Use absolute referencing where necessary so you can copy the formula through cell N9. NG -COUNTIFS/F6F32," "RPG. FG:F32, "-"Rp7,FG:F32,"-"&PS,FG:F32,-&p9) B G H L M Q R D E F Express Car Rental Rentals Initiated in Week Starting 4/5/2022 Created by Jason Easton N 0 P Car Rental Analysis 1 1 2 3 4 Total Cost Analysis Criteria Rewards Express Miles Credit Card Cash Payment Method 0 0 0 0 Analysis Criteria Rewards Express Mles Credit Card Cash Average Total Cost $26767 $39945 $258.56 $508.45 Total Cost $1,070 70 $2,796.18 $2,994 13 $1,907.80 Number of Rentals 27 0 5 Auto Type 6 Green Colection 7 Compact/Midsize B Compact/Midsize 9 Green Colection 10 Fullsize/Standard 11 SUV Minivan 12 SUV/Mirivan 13 Fullsize/Standard 14 Green Colection 15 Compact/Midsize 16 Fullsize/Standard 17 Fullsize/Standard 18 Fullsize/Standard 19 SUV/Minivan 20 SUV/Minivan 21 Green Colection 22 Green Colection 23 Green Colection 24 Fullsize/Standard 25 SUV/Minivan 26 SUV/Minivan 27 Fullsize/Standard 28 Fullsize/Standard 29 Compact/Midsize 30 Compact/Midsize 31 SUV/Minivan 32 Green Collection 33 Date Returned/or Payment Auto ld Date Rented Expected Return #Days Rented Method 988 2022/4/5 2022/4/B Credit Card 275 2022/4/5 2022/4/10 5 Cash 277 2022/4/9 2022/4/10 1 1 Express Miles 990 2022/4/5 2022/4/6 1 Credit Card 350 2022/4/5 2022/4/8 3 Credit Card 550 2022/4/5 2022/4/9 4 Rowards 551 2022/4/7 2022/4/10 3 Credit Card 352 2022/4/7 2022/4/9 2 Credit Card 999 2022/4/6 2022/4/9 Credit Card 275 2022/4/11 2022/4/15 7 Cash 355 2022/4/9 2022/4/16 7 Credit Card 356 2022/4/6 2022/4/8 2 Credit Card 350 2022/4/9 2022/4/13 4 Rewards 553 2022/4/8 2022/4/14 6 6 Express Miles 550 2022/4/11 2022/4/17 6 Cash 998 2022/4/9 2022/4/15 6 Credit Card 999 2022/4/10 2022/4/16 6 6 Express Miles 990 2022/4/7 2072/4/10 Credit Card 356 2022/4/9 2022/4/10 1 Rewards 551 2022/4/11 2022/4/15 4 Express Miles 554 2022/4/7 2022/4/9 2 Express Miles 352 2022/4/10 2022/4/11 1 Credit Card 356 2022/4/11 2022/4/17 6 Express Miles 276 2022/4/11 2022/4/14 3 Credit Card 277 2022/4/11 2022/4/15 4 Rowards 554 2022/4/10 2022/4/12 2 Cash 990 2022/4/11 2022/4/18 7 Express Miles Daily Rate $49.99 $76.49 $76.49 $49.99 $84.99 $104.99 $10499 $8499 $4999 $7549 $84.99 $84.99 $84.99 S104.99 S104.99 $49.99 34999 $4999 $84.99 $104.99 S104.99 $84.99 $84.99 $76.49 576.49 $101.99 $4999 Amount of Discount Gas Option 0.00% N 0.00% N 0.00% N 0.00% N 0.00% 20.00% Y 0.00% N 0004 Y 0004 N 0.004 N Y 0.00% Y Y 20.00% Y 0.00% Y 0.00% Y 0.00% N 0.00% N 0004 N 20.00% N 0.004 Y 0.00% Y 0.00% Y 0.00% Y 0.00% N 20.00% N 0.00% Y 0004 N Cost of Gas $000 $000 $0.00 $0.00 $ 57500 57500 3000 $7500 $0.00 $0.00 $7500 $7500 $75 00 575.00 $7500 3000 $000 $000 $0.00 $7500 $7500 $75.00 $7500 $0.00 $000 $7500 $0.00 $382.45 $76.49 $49.99 5329.97 $410.97 $314.97 $ $244.98 $149.97 $535 43 $669.93 $244.98 $346.97 5704.94 5704.94 $299.94 $299.94 $149.97 $57 99 $ $494.96 $284.98 $159.99 5584.94 $229.47 $244.77 $284.98 $349.96 $49991 $76 49 $34.99 $104.991 35 36 Rental Rates 37 Green Collection 3 Compact/Midsize 39 Fullsize/Standard 40 SUV/Minivan 41 Discount for Express 42 Miles or Rewards -43 44 Cost to Fill Tank 45 46 47 48 49 50 20 $75.00
