In cell K6, use the Countifs Function to count the number of orders from each vendor. Enter similar Formula in cell K7 -Kll. In cell L6, use the Sumif Function to total the value of all orders to each of the Vendors Enter similar Formulae in cell L7 -Lll

Type the full formula for me in paper

File Home Insert Page Layout Formulas Data Review View Help Share Com 2. Insert = 11 AA Calibri a Wrap Text General AT O 3 LA AX Delete Paste BIU y Sensitivity - 3 Merge & Center - %, 500 Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis Sensitivity J17 for 1 J K M N L Total Value of Items Ordered Vendor No. Of Order Edison Harmony Auto Parts Henderson Automotives Morristown Parts Parts Plus Penn Auto Parts A B D E F G H Beginning Ending Type Optimal Stock No. to Order Amount Each Value of Order Vendor 5 Inventory Inventory 6 AC Condenser 20 16 25 9 40 360 Penn Auto Parts 7 Alternator 12 10 15 5 120 600 Morristown Parts 8 Brake Duriaper 20 14 20 6 50 300 Parts Plus 9 Brake Disc 20 12 20 8 60 480 Parts Plus 10 Brake Pad 40 30 50 20 20 400 Morristown Parts 11 Clutch Kit 10 8 10 2 100 200 Parts Plus 12 Coil Springs 20 18 30 12 30 360 Penn Auto Parts 13 Cooling Fan 10 9 10 1 30 30 Edison Parts 14 Distributor Cap 10 6 10 4 40 160 Henderson Automotive 15 Driveshaft 5 5 5 5 0 200 O Harmony Auto Parts 16 Fuel Filter 30 10 30 20 10 200 Henderson Automotive 17 Fuel Pump 20 12 20 8 140 1,120 Morristown Parts 18 Oil Filter 10 6 10 4 10 40 Parts Plus 19 Radiator 6 4 10 6 100 600 Morristown Parts 20 Shocks 25 20 30 10 50 500 Penn Auto Parts 21 Starter 5 3 5 2 90 180 Edison Parts 22 Strut 5 5 5 5 0 40 0 Harmony Auto Parts 23 Thermostat 30 30 18 10 180 Parts Plus 24 Water Pump 10 8 10 2 200 400 Edison Parts 25 Window Motor 10 6 20 14 190 2,660 Penn Auto Parts 26 Wiper Arm 10 10 2 40 80 Penn Auto Parts 27 Wiper Blade 18 6 30 24 20 480 Harmony Auto Parts 28 Timing Belt 12 10 20 10 20 200 Parts Plus Inventory Accessories Sales Reps + 12 Activate Windows Go to Settings to activate Window Search for anything 9 x 0 10:10 26/11/2020