Spreadsheet: 858585d1707217846-please-help-find-formula-for-cost-analysis-example-etaf2
Sheet: Example

Collection date | 2023-12-01 00:00:00 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | 2023-12-08 00:00:00 | 2023-12-09 00:00:00 | 2023-12-10 00:00:00 | 2023-12-11 00:00:00 | 2023-12-12 00:00:00 | 2023-12-13 00:00:00 | 2023-12-14 00:00:00 | 2023-12-15 00:00:00 | 2023-12-16 00:00:00 | 2023-12-17 00:00:00 | 2023-12-18 00:00:00 | 2023-12-19 00:00:00 | 2023-12-20 00:00:00 | 2023-12-21 00:00:00 | 2023-12-22 00:00:00 | 2023-12-23 00:00:00 | 2023-12-24 00:00:00 | 2023-12-25 00:00:00 | 2023-12-26 00:00:00 | 2023-12-27 00:00:00 | 2023-12-28 00:00:00 | 2023-12-29 00:00:00 | 2023-12-30 00:00:00 | 2023-12-31 00:00:00
Example |  | 16 |  | 16 |  | 18 | 16 |  | 21 |  | 20 |  | 20 | 20 |  | 22 |  | 22 |  | 22 | 20 | 5 |  | 16 | 14 |  | 16 | 15 | 9 |  | 14
Example 2 |  | 2 | 3 | 2 | 2 | 2 | 2 |  | 2 | 2 | 4 | 1 | 2 | 2 | 2 | 10 | 9 | 8 | 7 | 4 | 3 | 2 |  | 3 | 5 | 1 | 3 | 1 |  | 1 | 2
Example 3 | 2 |  | 2 | 2 | 7 | 4 | 1 | 2 |  | 2 | 2 | 8 | 4 | 1 | 2 |  | 2 | 2 | 7 | 4 | 1 | 2 |  | 2 | 10 | 7 | 3 | 2 | 4 |  | 3
TOTAL PALLETS
Collection date | 2023-12-01 00:00:00 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 | 2023-12-08 00:00:00 | 2023-12-09 00:00:00 | 2023-12-10 00:00:00 | 2023-12-11 00:00:00 | 2023-12-12 00:00:00 | 2023-12-13 00:00:00 | 2023-12-14 00:00:00 | 2023-12-15 00:00:00 | 2023-12-16 00:00:00 | 2023-12-17 00:00:00 | 2023-12-18 00:00:00 | 2023-12-19 00:00:00 | 2023-12-20 00:00:00 | 2023-12-21 00:00:00 | 2023-12-22 00:00:00 | 2023-12-23 00:00:00 | 2023-12-24 00:00:00 | 2023-12-25 00:00:00 | 2023-12-26 00:00:00 | 2023-12-27 00:00:00 | 2023-12-28 00:00:00 | 2023-12-29 00:00:00 | 2023-12-30 00:00:00 | 2023-12-31 00:00:00
Example
Example 2
Example 3
TOTAL PALLETS
Customer | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Costco | 110 | 90 | 90 | 90 | 90 | 70 | 70 | 70 | 70 | 70 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65
Iceland | 60 | 60 | 60 | 60 | 60 | 60 | 55 | 55 | 55 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
Iceland | 60 | 60 | 60 | 60 | 60 | 60 | 55 | 55 | 55 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
Iceland | 60 | 60 | 60 | 60 | 60 | 60 | 55 | 55 | 55 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
Iceland | 60 | 60 | 60 | 60 | 60 | 60 | 55 | 55 | 55 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52 | 52
Iceland Manufacturing | 90 | 90 | 90 | 75 | 75 | 75 | 70 | 70 | 70 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65
Example | 80 | 80 | 80 | 80 | 60 | 60 | 60 | 60 | 60 | 60 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
Example 2 | 55 | 55 | 55 | 55 | 45 | 45 | 45 | 45 | 45 | 45 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
Example 3 | 40 | 40 | 40 | 40 | 30 | 30 | 30 | 30 | 30 | 30 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 | I have different pallet counts collected per day and I need to find how much it costs. Depending on pallet quantities - it might be different per pallet price.
 | Pallet quantities are in B3:AF5.
 | Cost per pallet in B26:AE28.