formula yo complete total shipping weights per state? and average shipping cost per pound? excel

A B H Date Carrier Name Involce Amount Shipping Cost per Pound ONJA 02- M1 Sung Testing the 24Seven Shipping Weight 2497 6744 02 Do Jan OT Jan 111 Devon. 0 Count On Us Destination State OM OH CO OR AZ NY PA A? NY PA PA GYON 4356 4356 SE 54 567 10.100 1420 57000 10292 1107 31.01 $1.00 51 05 100 Invoice Number 1 2 10001 3 10002 4 10000 5 TOODA TODOS 40006 10007 0 100 10 10000 11 TOOTO 12 10011 13 10012 14 10013 15 10014 16 1055 ST 10010 18 10 10010 20 10019 21 10020 22 1000 23 10022 24 10023 Total of invoices Per Carrier 24 Seven 105 Count Us 139 Sure Shop 24 Testing Time 1721 The Torw Average Invoice Con Per Carrier 24 Seven 1201200907 Court oss 349 1647 Sus Shoping 5053 Testing Time Them Tomonew 5000172140 Sumo 1001 7457 1007 TOAT 0070 100 4344 124 14. Tong Cestone menopang Con US 24 Seven Countou COR Targe COUNEORIUS $1.00 $9.000 S044 14705 ST2 32.765 PA NY TX N 10.17 Than 5.30 30.00 1099 6579 000 2000 2233 OOO 10.1 Tots Shipping costs. Per PA AZ LOR STE TX 1 co AN * WA WY 1 100 20 Jan. OP co Count On Us Burcing TOYO SO 21 11.03 073 Nan 17 247 81 172 5450 1200 STRO 31 10023 1000 19 1-10 NY WA CO OH OH WA TX WA WA TO Tha Strong - 21 27 20 pet 30 31 12 33 34 35 TotalShipping weight State PA AZ OR TX 100 OH WA 34 H4100 100 os 3507 10 WA MY 100 THI H | 19 100 Avenge Shoping to PAESE Count on s sppng Testing Time Theme CO OLD longc37 SE Yi 40 41 104 COURS NY CO PA 102 50 15 20040 + 4 Solution Operational Efficiencies Tady Ps