steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
Hello, I have this report that can vary in rows. Starting in column L thru AK each column has a different amount noted in row 6. Starting in ROW 8 each row with data will have different quantity's noted in those columns. I need the best way to total each row in column AL. Any help would be greatly appreciated.
| Book1 | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| J | K | L | M | N | O | P | Q | R | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | ||||
| 1 | |||||||||||||||||||||||||||||||
| 2 | |||||||||||||||||||||||||||||||
| 3 | |||||||||||||||||||||||||||||||
| 4 | $ 18.00 | $ 6.00 | $ - | $ 25.00 | $ - | $ 2.25 | $ 3.25 | $ 1.50 | $ - | $ 13.00 | $ 5.00 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | |||||
| 5 | |||||||||||||||||||||||||||||||
| 6 | EACH: | $ 6.00 | $ 2.00 | $ 4.00 | $ 25.00 | $ 25.00 | $ 0.75 | $ 0.65 | $ 0.15 | $ 0.20 | $ 13.00 | $ 5.00 | $ 42.00 | $ 28.00 | $ 32.00 | $ 6.00 | $ 4.00 | $ 7.00 | $ 10.00 | $ 50.00 | $ 25.00 | $ 0.28 | $ 0.14 | $ 2.00 | $ 10.00 | $ 15.00 | |||||
| 7 | Carrier | Master Tracking | Order Charge | Fedex Express, Ground Processing | UPS, DHL, Etc Processing | Expedited Parcel Order | Expedited LTL Order - $25.00 ea | Carton Charge | Unit Pick Charge | Customer Labels | FedEx Labels | FedEx Pallet | Customer Pallet | FedEx Labor | Temp Labor | Returns Check | POD Request | Kitting 1 - 8 Lines | Kitting 9 - 14 Lines | Kitting 15 - 20 Lines | Receiving Storage - $0.28/cuft 1st - 15th $50.00 min | Receiving Storage - $0.28/cuft 16th - EOM $25.00 min | Receiving Storage $0.28/cutf - More than 179cuft/5.6CBM 1st - 15th | Receiving Storage $0.28/cutf - More than 179cuft/5.6CBM 16th - EOM | Carton Handling In | Pallet Handling In | Mixed Pallet Handling In | Dist Charges | |||
| 8 | FDEG | 545274563715 | 1 | 1 | 1 | 10 | 1 | ||||||||||||||||||||||||
| 9 | FDEG | 545274563667 | 1 | 1 | 1 | 3 | 1 | ||||||||||||||||||||||||
| 10 | FDEG | 545274563690 | 1 | 1 | 4 | ||||||||||||||||||||||||||
| 11 | 3 | 3 | 0 | 1 | 0 | 3 | 5 | 10 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $ - | |||||
10.09.2022 - 10.15.2022 | |||||||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| L4 | L4 | =Table15[[#Totals],[Order Charge]]*L6 |
| M4 | M4 | =Table15[[#Totals],[Fedex Express, Ground Processing]]*M6 |
| N4 | N4 | =Table15[[#Totals],[UPS, DHL, Etc Processing]]*N6 |
| O4 | O4 | =Table15[[#Totals],[Expedited Parcel Order]]*O6 |
| P4 | P4 | =Table15[[#Totals],[Expedited LTL Order - $25.00 ea]]*P6 |
| Q4 | Q4 | =Table15[[#Totals],[Carton Charge]]*Q6 |
| R4 | R4 | =Table15[[#Totals],[Unit Pick Charge]]*R6 |
| T4 | T4 | =Table15[[#Totals],[Customer Labels]]*T6 |
| U4 | U4 | =Table15[[#Totals],[FedEx Labels]]*U6 |
| V4 | V4 | =Table15[[#Totals],[FedEx Pallet]]*V6 |
| W4 | W4 | =Table15[[#Totals],[Customer Pallet]]*W6 |
| X4 | X4 | =Table15[[#Totals],[FedEx Labor]]*X6 |
| Y4 | Y4 | =Table15[[#Totals],[Temp Labor]]*Y6 |
| Z4 | Z4 | =Table15[[#Totals],[Returns Check]]*Z6 |
| AA4 | AA4 | =Table15[[#Totals],[POD Request]]*AA6 |
| AB4 | AB4 | =Table15[[#Totals],[Kitting 1 - 8 Lines]]*AB6 |
| AC4 | AC4 | =Table15[[#Totals],[Kitting 9 - 14 Lines]]*AC6 |
| AD4 | AD4 | =Table15[[#Totals],[Kitting 15 - 20 Lines]]*AD6 |
| AE4 | AE4 | =Table15[[#Totals],[Receiving Storage - $0.28/cuft 1st - 15th $50.00 min]]*AE6 |
| AF4 | AF4 | =Table15[[#Totals],[Receiving Storage - $0.28/cuft 16th - EOM $25.00 min]]*AF6 |
| AG4 | AG4 | =Table15[[#Totals],[Receiving Storage $0.28/cutf - More than 179cuft/5.6CBM 1st - 15th]]*AG6 |
| AH4 | AH4 | =Table15[[#Totals],[Receiving Storage $0.28/cutf - More than 179cuft/5.6CBM 16th - EOM]]*AH6 |
| AI4 | AI4 | =Table15[[#Totals],[Carton Handling In]]*AI6 |
| AJ4 | AJ4 | =Table15[[#Totals],[Pallet Handling In]]*AJ6 |
| AK4 | AK4 | =Table15[[#Totals],[Mixed Pallet Handling In]]*AK6 |
| AL4 | AL4 | =Table15[[#Totals],[Dist Charges]] |
| L11 | L11 | =SUBTOTAL(109,[Order Charge]) |
| M11 | M11 | =SUBTOTAL(109,[Fedex Express, Ground Processing]) |
| N11 | N11 | =SUBTOTAL(109,[UPS, DHL, Etc Processing]) |
| O11 | O11 | =SUBTOTAL(109,[Expedited Parcel Order]) |
| P11 | P11 | =SUBTOTAL(109,[Expedited LTL Order - $25.00 ea]) |
| Q11 | Q11 | =SUBTOTAL(109,[Carton Charge]) |
| R11 | R11 | =SUBTOTAL(109,[Unit Pick Charge]) |
| T11 | T11 | =SUBTOTAL(109,[Customer Labels]) |
| U11 | U11 | =SUBTOTAL(109,[FedEx Labels]) |
| V11 | V11 | =SUBTOTAL(109,[FedEx Pallet]) |
| W11 | W11 | =SUBTOTAL(109,[Customer Pallet]) |
| X11 | X11 | =SUBTOTAL(109,[FedEx Labor]) |
| Y11 | Y11 | =SUBTOTAL(109,[Temp Labor]) |
| Z11 | Z11 | =SUBTOTAL(109,[Returns Check]) |
| AA11 | AA11 | =SUBTOTAL(109,[POD Request]) |
| AB11 | AB11 | =SUBTOTAL(109,[Kitting 1 - 8 Lines]) |
| AC11 | AC11 | =SUBTOTAL(109,[Kitting 9 - 14 Lines]) |
| AD11 | AD11 | =SUBTOTAL(109,[Kitting 15 - 20 Lines]) |
| AE11 | AE11 | =SUBTOTAL(109,[Receiving Storage - $0.28/cuft 1st - 15th $50.00 min]) |
| AF11 | AF11 | =SUBTOTAL(109,[Receiving Storage - $0.28/cuft 16th - EOM $25.00 min]) |
| AG11 | AG11 | =SUBTOTAL(109,[Receiving Storage $0.28/cutf - More than 179cuft/5.6CBM 1st - 15th]) |
| AH11 | AH11 | =SUBTOTAL(109,[Receiving Storage $0.28/cutf - More than 179cuft/5.6CBM 16th - EOM]) |
| AI11 | AI11 | =SUBTOTAL(109,[Carton Handling In]) |
| AJ11 | AJ11 | =SUBTOTAL(109,[Pallet Handling In]) |
| AK11 | AK11 | =SUBTOTAL(109,[Mixed Pallet Handling In]) |
| AL11 | AL11 | =SUBTOTAL(109,[Dist Charges]) |
