Please provide exact COUNTIF and SUMIF equations specific to this case.
Everything provided is what is provided. There is no other information.
OO Renter Furniture Mogan LR-3pc Novarre LR-3pc + Chico GR-Electronic Roman BR-King DiGrigoro LR-3pc Ibe BR-Queen Zischke DR-Table/8 Gilhooly LR-3pc Guys LR-3pc Swartz DR-Table/8 Dill GR-Pool/Darts Udinotti LR-3pc + Aserty DR-Table/8 McGraw BR-Twin Mclver DR-Table/8 Schenck LR-3pc Bindner LR-3pc Blum LR-3pc + Reed LR-3pc Turrell LR-3pc + Aserty LR-3pc + Shenal BR-Queen Meglech BR-Twin Metz BR-King Senior LR-3pc Scherzel LR-3pc Meglech BR-Queen Mogan LR-3pc Hofmann DR-Table/4 Guys GR-Electronic Rental Da 8/15/17 8/28/17 7/13/17 7/17/17 7/2/17 8/31/17 8/30/17 8/22/17 7/15/17 7/3/17 7/17/17 9/11/17 7/30/17 9/30/17 8/24/17 9/5/17 9/8/17 8/2/17 8/9/17 8/12/17 7/24/17 8/1/17 9/5/17 8/16/17 8/15/17 8/8/17 9/30/17 9/19/17 7/28/17 7/17/17 Rental Period Insurance 6 Yes 6 Yes 12 Yes 6 Yes 6 Yes 6 Yes 6 Yes 6 No 6 No 6 Yes 6 Yes 6 No 6 Yes 6 Yes 6 Yes 6 Yes 6 No 6 Yes 6 Yes 6 Yes 6 Yes 12 Yes 6 Yes 6 No 12 Yes 6 Yes 6 Yes 12 Yes 12 Yes 6 Yes Shipping Group Code Code Pickup Pickup D Truck E Truck D Pickup Truck C Pickup D Truck C Truck Pickup D Pickup E Truck D Pickup D Pickup Pickup D Pickup C Pickup Pickup D Truck Truck D Pickup D Truck Truck A Truck D Pickup Pickup Pickup Truck Pickup A Truck E Insurance Shipping Rental Fe Charge Charge Total Co $ 200 $ 120 0 $ 320 $ 250 $ 150 0 $ 400 $ 750 $ 480 $ 50 $ 1,280 $ 250 $ 150 $ 50 $ 450 $ 200 $ 120 0 $ 320 $ 200 $ 120 $ 50 $ 370 250 $ 150 0 $ 400 $ 200 $ $ 50 $ 250 $ 200 $ $ 50 $ 250 $ 250 $ 150 $ 400 $ 400 $ 240 $ 640 $ 250 $ $ 50 $ 300 $ 250 $ 150 $ 400 $ 100 $ 60 $ 160 $ 250 $ 150 $ 400 $ 200 $ 120 $ 320 $ 200 $ $ 200 $ 250 $ 150 $ 400 $ 200 $ 120 $ 50 $ 370 $ 250 $ 150 $ 50 $ 450 $ 250 $ 150 0 $ 400 $ 375 $ 240 $ 50 $ 665 $ 100 $ 60 $ 50 $ 210 $ 250 $ $ 50 $ 300 375 $ 240 $ 615 $ 200 $ 120 0 $ 320 $ 200 $ 120 0 $ 320 $ 375 $ 240 $ 50 $ 665 $ 175 $ 120 0 $ 295 $ 400 $ 240 $ 50 $ 690 OO 0 D 0 300 150 D 0 0 C 0 Ingraham LR-3pc Lundquist LR-3pc + Werner LR-3pc + Aserty BR-Queen Meglech LR-3pc Battenberg BR-Queen Fleming DR-Table/8 Acconci LR-3pc Cox GR-Electronic Meglech BR-Twin Allen LR-3pc 8/30/17 8/14/17 7/6/17 7/7/17 9/14/17 9/30/17 7/12/17 7/9/17 9/29/17 8/4/17 9/15/17 6 No 12 Yes 6 Yes 6 No 6 Yes 6 Yes 6 No 6 Yes 12 Yes 6 Yes 12 Yes Pickup Pickup Pickup Pickup Pickup Pickup Truck Truck Pickup Pickup Truck $ $ $ $ $ $ $ $ $ $ $ 200 $ 475 $ 250 $ 200 $ 200 $ 200 $ 250 $ 200 $ 750 $ 100 $ 375 $ D 0 200 775 400 200 320 320 300 370 1,230 160 $ $ $ $ $ $ 50 $ 50 $ $ $ 50 $ 120 120 $ 120 $ 480 60 240 $ C E Oo A 665 Furniture Group Furniture BR-King D BR-Queen BR-Twin . DR-Table/4 A DR-Table/8 D GR-Pool/Darts B GR-Electronic E LR-3pc LR-3pc + D Furniture Rental Charges Rental for 6- Rental for 9. Monthly months months Insurance $ 100 $ 175 $ 10 $ 150 $ 250 $ 15 $ 200 $ 375 $ 20 $ 250 $ 475 $ 25 $ 400 $ 750 $ 40 Group A B D E Group Code Key to Furniture Codes BR-King Bedroom with King Bed BR-Queen Bedroom with Queen Bed BR-Twin Bedroom with Twin Bed DR-Table/4 Dining Room - Table for 4 DR-Table/8 Dining Room - Table for 8 GR-Pool/Darts Game Room - Pool Table & Darts GR-Electonic Game Room - Electronic Games Living Room - 3 piece LR-3pc + Living Room - 3 piece with tables LR-3pc Rental Summary Rentals # Rentals Total Rental $ 6-months 33 12-months 7 Total In the Rental Report worksheet, complete the Rental Summary report by creating formulas in the range C4:D5 using the COUNTIF and SUMIF functions. Field Renter Furniture Rental Date Rental Period Insurance Shipping Code Description Renter's name Type of furniture Date rental begins Number of months Furniture insured Shipping method Furniture assigned to group code Rental fee Insurance charge Shipping Cost Total Cost Data Definition Table Data Type Notes Text Text Date Enter dates using mm/dd/yyy Number 6 or 12 Text Yes or No Text Pickup or Truck Group Code Text Rental Fee Insurance Charge Shipping Change Total Cost Number Text Text Number A, B, C, D, E Accounting format with two decimal places Accounting format with two decimal places Accounting format with two decimal places Accounting format with two decimal places
