please solve formulas :)

1 2 1 4 3 1 5 3 Looking at shipments, at employee performance, and at services required by customers; Quickstove managment performs several analyses. Task # Points Task Description 3 Use the COUNTIF function in cell 35 to determine the number of shipments handled by employee Merrill. Copy your function in cell 18 and paste it down to J11 to complete the "Count" column of the "Shipments by Employee" table for individual employees, 3 3 Use the SUMIF function in cell K6 to determine the value of the shipments handled by employee Merrill. Copy your function in cell K8 and paste it down to complete the "Total Value column of the "Shipments by Employee" table for individual employees, Use the AVERAGEIF function in cell L8 to determine the average value of the shipments handled by employee Merril Copy your function in cell 18 and paste it down to complete the "Average Value column of the "Shipments by Employee table for individual employees. Use the appropriate functions in cells J12,K12 and L12 to calculate the overall number of shipments, total value of all shipments and average value of all shipments. Use the COUNTIF function in cell 117 to determine the number of regular shipments 9 Copy your function in cell 17 and paste it down to complete the "Count column of the "Shipments by Shipping Class table. 3 Use the SUMIF function in cell K17 to determine the Total Value of the regular shipments, Copy your function in cell K17 and paste it down to complete the "Total Value column of the "Shipments by Shipping Class"table. Use the AVERAGETF function in coll L17 to determine the average value of the regular shipments 13 1 Copy your function in cell L17 and paste it down to complete the "Average Vale" column of the shipments by Shipping Class"table 6 1 7 4 8 3 1 10 11 1 12 3 A B D E F G H K WN 2 3 4 5 Looking at shipments, at employee performance, and at services required by customers, Quickstove managment performs several analyses. Shipments by Employee Total Value Average Value Count Merrill Frank George Howard All 6 Order Ship To 7 1003 8 1004 WA 9 1007 10 1011 11 1027 12 1041 13 1042 14 1050 15 1058 16 1050 17 1060 WA 10 1062 19 1073 20 1074 21 1088 WA 22 1094 23 1109 24 1120 25 1255 26 1262 27 1265 WA 28 1207 Shipments by Shipping Class Count Total Value Average Value 23355558523599328533 ProductID Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Con 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 101 Quick Stove. Con 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Con Ship Class Value Employee Express $ 68.80 Merrill Express $ 86.00 George Regular $ 120,39 George Express $120.39 Merrill Overnite $ 17.55 Frank Overnite S 4.00 Frank Overnite $ 69.98 George Overnite $ 274.32 Frank Express $274,32 Frank Regular S 15.68 Frank Overnite s 69.98 George Regular $ 60.80 George Overnite S 34.99 Merrill Overnite S 19.60 George OverniteS1.00 Frank Express S 8.00 George Express $ 8.00 Howard Express $ 38,00 George Overnite $34.99 George Regular $102.87 Merrell Express $ 34,99 Merril Overnite $ 102.87 Merrill Regular Express Overnite A 1268 1364 B MT AZ UT CA 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 1417 1629 1635 1661 1666 1677 1686 1701 1708 1712 1718 1720 1725 1733 1746 1748 1776 1797 1814 1834 1835 1839 1842 1873 1877 1897 1913 CO AZ OR WA CA CO AZ AZ OR UT WA CA NV MT WA AZ CO CA CA MT CA CA NV AZ D 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 110 Firebox Bundle 110 Firebox Bundle 101 QuickStove Can 101 QuickStove Can 114 Cube Stove + 2 Fuel Disks 114 Cube Stove + 2 Fuel Disks 113 Firebox Stove w/ Fuel 113 Firebox Stove w/ Fuel 114 Cube Stove + 2 Fuel Disks 108 QuickStove Fuel Disk 109 Folding Campfire Stove 121 Firebox Master Combo Kit 118 Firebox Deluxe Combo Kit 118 Firebox Deluxe Combo Kit E F G Regular $34.99 Merrill Regular $ 398.89 Frank Overnite $ 37.85 George Express $ 10.00 George Express $69.98 Merrill Regular $ 47.50 Merrill Express $ 19.60 Merrill Express $ 31.54 Frank Overnite $ 19.95 Frank Overnite $ 19.95 Merrill Overnite $ 19.95 Merrill Express $ 47.31 Frank Overnite $ 39.90 Merrill Overnite $ 78.20 George Express $ 78.20 Frank Regular $ 175.50 Merrill Express $ 87.75 George Overnite $ 78.20 Howard Overnite $ 78.20 Merrill Express $ 49.90 George Regular $ 24.95 Frank Overnite $ 49.95 Merrill Overnite $49.95 George Express $ 49.90 Merrill Overnite $ 18.92 Howard Regular $ 59.99 Merrill Overnite $ 144.98 George Regular $ 89.99 George Regular $ 89.99 George