Spreadsheet: 882808d1731288665-sum-formula-for-the-material-received-up-to-a-given-date-sum-function
Sheet: Sum

 |  | MATERIAL STATUS |  |  |  |  |  |  |  |  |  |  |  | 2024-11-07 00:00:00
 |  | Date | LOCATION 1 |  |  |  |  |  |  | LOCATION 2
 |  |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7
 |  | OPENING | 19.68 | 0 |  | 555.54 |  | 1552 | 3840 |  | 0 | 589.5 | 539.83 |  | 2332
 |  | 2024-08-01 00:00:00 |  |  | 120 | 125.77
 |  | 2024-08-02 00:00:00 |  |  | 300 | 129.87 |  |  |  |  |  | 75 | 40.08
 |  | 2024-08-03 00:00:00 |  |  |  | 67.98
 |  | 2024-08-04 00:00:00
 |  | 2024-08-05 00:00:00 |  |  |  | 123.67
 |  | 2024-08-06 00:00:00 |  |  | 300 | 230.86
 |  | 2024-08-07 00:00:00 |  |  |  | 215.71 |  |  |  |  |  | 160 | 61.25
 |  | 2024-08-08 00:00:00 |  |  | 300 | 266.18 |  |  |  |  |  | 128 | 47.41 |  |  | 400
 |  | 2024-08-09 00:00:00 | 0 |  | 112 | 57.98 | 0 | 0 | 0
 |  | 2024-08-10 00:00:00 | 0 |  | 112 | 51.44 | 0 | 0 | 0
 |  | 2024-08-11 00:00:00
 |  | 2024-08-12 00:00:00 | 0 |  | 120 | 124.24 | 0 | 0 | 0 |  |  |  |  |  |  | 800
 |  | 2024-08-13 00:00:00 | 0 |  | 0 | 272.25 | 0 | 0 | 800
 |  | 2024-08-14 00:00:00 | 0 |  | 0 | 268.39 | 0 | 0 | 400 |  |  |  |  |  |  | 560
 |  | 2024-08-15 00:00:00 | 0 |  | 300 | 301.75 | 0 | 0 | 800
 |  | 2024-08-16 00:00:00 | 0 |  | 0 | 329.32 | 0 | 0 | 200
 |  | 2024-08-17 00:00:00 | 0 |  | 0 | 58.5 | 0 | 0 | 200 |  |  | 96
 |  | 2024-08-18 00:00:00
 |  | 2024-08-19 00:00:00 |  |  |  | 172.2 |  |  |  |  |  | 48
 |  | 2024-08-20 00:00:00 |  |  | 0 | 276.92 | 0 | 0 | 0 | 0 |  | 0 | 99.8
 |  | 2024-08-21 00:00:00 |  |  |  | 411.34
 |  | 2024-08-22 00:00:00 |  |  | 300 | 392.18
 |  | 2024-08-23 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | 460.68
 |  | 2024-08-24 00:00:00 |  |  |  | 49.12 |  |  |  |  |  | 58 | 189.4
 |  | 2024-08-25 00:00:00
 |  | 2024-08-26 00:00:00 |  |  |  | 262.96
 |  | 2024-08-27 00:00:00 |  |  |  | 356.54
 |  | 2024-08-28 00:00:00 |  | 98.46 |  | 55.04
 |  | 2024-08-29 00:00:00 |  | 113.08 |  | 218.68
 |  | 2024-08-30 00:00:00 |  | 57.86 |  | 135.88
 |  | 2024-08-31 00:00:00 |  | 0 |  | 0
 |  | 2024-09-01 00:00:00
 |  | 2024-09-02 00:00:00 |  | 108.34 |  | 433.54
 |  | 2024-09-03 00:00:00 |  | 141.66 |  | 25.74 |  |  |  |  |  |  | 155.16
 |  | 2024-09-04 00:00:00 |  | 56.4 |  | 0 | 83.16 |  |  |  |  |  | 0
 |  | 2024-09-05 00:00:00 |  | 0 |  | 0 | 406.58 |  |  |  |  |  | 0
 |  | 2024-09-06 00:00:00 |  | 0 |  | 0 | 298.64 |  |  |  |  |  | 105.6
 |  | 2024-09-07 00:00:00 |  |  | 290
 |  | 2024-09-08 00:00:00
 |  | 2024-09-09 00:00:00 |  |  | 203 | 0 |  |  |  |  |  |  | 0
 |  | 2024-09-10 00:00:00 |  |  | 58
 |  | 2024-09-11 00:00:00 |  |  | 261 |  |  |  | 800 |  |  |  | 0
 |  | 2024-09-12 00:00:00 |  |  | 0 | 380.02 |  |  | 600 |  |  |  | 0
 |  | 2024-09-13 00:00:00 |  |  |  | 393.48 |  |  | 600
 |  | 2024-09-14 00:00:00 |  |  |  | 230.82 |  |  | 600
 |  | 2024-09-15 00:00:00 |  |  |  | 0
 |  | 2024-09-16 00:00:00 |  |  |  | 0
 |  | 2024-09-17 00:00:00
 |  | 2024-09-18 00:00:00 |  |  |  |  | 50.04
 |  | 2024-09-19 00:00:00 |  |  |  |  | 54.08 |  | 800
 |  | 2024-09-20 00:00:00 |  |  |  |  | 54 |  | 600 |  |  | 68 | 51
 |  | 2024-09-21 00:00:00 |  |  |  | 54 | 189 |  | 0 |  |  | 68 | 85
 |  | 2024-09-22 00:00:00 |  |  |  | 0 | 0 |  | 1400
 |  | 2024-09-23 00:00:00 |  |  |  |  | 294.64 | 128 | 1000 |  |  |  | 119
 |  | 2024-09-24 00:00:00 |  |  |  |  | 0 | 128 | 1000 |  |  |  | 136
 |  | 2024-09-25 00:00:00 |  |  |  | 216 | 162 | 128 | 800 |  |  | 68 | 68
 |  | 2024-09-26 00:00:00 |  |  |  |  | 135 | 128 | 1000 |  |  | 135 | 135
 |  | 2024-09-27 00:00:00 |  |  |  | 0 | 200 | 64 | 1600 |  |  | 0 | 308
 |  | 2024-09-28 00:00:00 |  |  |  | 189 | 0 | 128 | 800 |  |  | 0 | 0
 |  | 2024-09-29 00:00:00 |  |  |  | 0 | 0
 |  | 2024-09-30 00:00:00 |  |  |  | 140 | 1026 | 64 | 0
 |  | 2024-10-01 00:00:00 |  |  |  | 23.42 | 180.54 | 64 | 0
 |  | 2024-10-02 00:00:00 |  |  |  | 111.48 | 651.26 | 192 | 600
 |  | 2024-10-03 00:00:00 |  |  | 290 | 141.16 | 0 | 0 | 600
 |  | 2024-10-04 00:00:00 |  |  | 174 | 315.06 | 0 | 0 | 600 |  |  |  | 34
 |  | 2024-10-05 00:00:00 |  |  | 0 | 29.8 | 0 | 0 | 600 |  |  |  | 0
 |  | 2024-10-06 00:00:00
 |  | 2024-10-07 00:00:00 |  |  | 87 | 373.48 | 0 | 0 | 200 |  |  |  | 0
 |  | 2024-10-08 00:00:00 |  |  | 0 | 530.59 | 0 | 0 | 400 |  |  |  | 0
 |  | 2024-10-09 00:00:00 |  |  | 0 | 416.22 | 0 | 308 | 800 |  |  |  | 102
 |  | 2024-10-10 00:00:00 |  |  | 0 | 499.5 | 0 | 0 | 800 |  |  |  | 102
 |  | 2024-10-11 00:00:00 |  |  | 0 | 491.98 | 0 | 0 | 800 |  |  |  | 136
 |  | 2024-10-12 00:00:00 |  |  | 0 | 291.34 | 0 | 0 | 200 |  |  |  | 68
 |  | 2024-10-13 00:00:00
 |  | 2024-10-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | 561.14
 |  | 2024-10-15 00:00:00 |  |  |  |  |  |  | 1000 |  |  |  | 462.16
 |  | 2024-10-16 00:00:00 |  |  |  |  |  |  | 800 |  |  | 34 | 492.1
 |  | 2024-10-17 00:00:00 |  |  |  |  |  |  | 800 |  |  | 68 | 440.5
 |  | 2024-10-18 00:00:00 |  |  |  |  |  |  | 600 |  |  | 102 | 570.76
 |  | 2024-10-19 00:00:00 |  |  |  |  |  |  | 200 |  |  | 34 | 280.89
 |  | 2024-10-20 00:00:00
 |  | 2024-10-21 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | 622.74
 |  | 2024-10-22 00:00:00 |  |  |  |  |  |  | 1000 |  |  | 0 | 668.26
 |  | 2024-10-23 00:00:00 |  |  |  |  |  |  | 200 |  |  |  | 643.72
 |  | 2024-10-24 00:00:00 |  |  |  |  |  |  | 1400 |  |  |  | 736.52
 |  | 2024-10-25 00:00:00 |  |  |  | 382.12 |  |  | 800 |  |  |  | 286.8
 |  | 2024-10-26 00:00:00 |  |  |  | 176.12 |  |  | 600 |  |  |  | 102
 |  | 2024-10-27 00:00:00 |  |  |  | 0
 |  | 2024-10-28 00:00:00 |  |  |  | 460.6 |  |  | 1000 |  |  |  | 136
 |  | 2024-10-29 00:00:00 |  |  |  |  |  |  | 600 |  |  |  | 232.46
 |  | 2024-10-30 00:00:00 |  |  |  | 58.98 |  |  | 0 |  |  |  | 28.8
 |  | 2024-10-31 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | 2024-11-01 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | 2024-11-02 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | 2024-11-03 00:00:00 |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | 2024-11-04 00:00:00 |  |  |  | 391.58 |  |  |  |  |  |  | 51
 |  | 2024-11-05 00:00:00 |  |  |  | 321.72 |  |  | 1000 |  |  |  | 0
 |  | 2024-11-06 00:00:00 |  | 83.6 |  | 86.92 |  |  | 400 |  |  |  | 231.88
 |  | 2024-11-07 00:00:00 |  | 87.88 |  | 87.76 |  |  | 600 |  |  |  | 352.46
 |  | 2024-11-08 00:00:00
 |  | 2024-11-09 00:00:00
 |  | 2024-11-10 00:00:00
 |  | 2024-11-11 00:00:00
 |  | 2024-11-12 00:00:00
 |  | 2024-11-13 00:00:00
 |  | 2024-11-14 00:00:00
 |  | 2024-11-15 00:00:00
 |  | 2024-11-16 00:00:00
 |  | 2024-11-17 00:00:00
 |  | 2024-11-18 00:00:00
 |  | 2024-11-19 00:00:00
 |  | 2024-11-20 00:00:00
 |  | 2024-11-21 00:00:00
 |  | 2024-11-22 00:00:00
 |  | 2024-11-23 00:00:00
 |  | 2024-11-24 00:00:00
 |  | 2024-11-25 00:00:00
 |  | 2024-11-26 00:00:00
 |  | 2024-11-27 00:00:00
 |  | 2024-11-28 00:00:00
 |  | 2024-11-29 00:00:00
 |  | 2024-11-30 00:00:00
 |  | 2024-12-01 00:00:00
 |  | 2024-12-02 00:00:00
 |  | 2024-12-03 00:00:00
 |  | 2024-12-04 00:00:00
 |  | 2024-12-05 00:00:00
 |  | 2024-12-06 00:00:00
 |  | 2024-12-07 00:00:00
 |  | 2024-12-08 00:00:00
 |  | 2024-12-09 00:00:00
 |  | 2024-12-10 00:00:00
 |  | 2024-12-11 00:00:00
 |  | 2024-12-12 00:00:00
 |  | 2024-12-13 00:00:00
 |  | 2024-12-14 00:00:00
 |  | 2024-12-15 00:00:00
 |  | 2024-12-16 00:00:00
 |  | 2024-12-17 00:00:00
 |  | 2024-12-18 00:00:00
 |  | 2024-12-19 00:00:00
 |  | 2024-12-20 00:00:00
 |  | 2024-12-21 00:00:00
 |  | 2024-12-22 00:00:00
 |  | 2024-12-23 00:00:00
 |  | 2024-12-24 00:00:00
 |  | 2024-12-25 00:00:00
 |  | 2024-12-26 00:00:00
 |  | 2024-12-27 00:00:00
 |  | 2024-12-28 00:00:00
 |  | 2024-12-29 00:00:00
 |  | 2024-12-30 00:00:00
 |  | 2024-12-31 00:00:00
 |  | 2025-01-01 00:00:00
 |  | 2025-01-02 00:00:00
 |  | 2025-01-03 00:00:00
 |  | 2025-01-04 00:00:00
 |  | 2025-01-05 00:00:00
 |  | 2025-01-06 00:00:00
 |  | 2025-01-07 00:00:00
 |  | 2025-01-08 00:00:00
 |  | 2025-01-09 00:00:00
 |  | 2025-01-10 00:00:00
 |  | 2025-01-11 00:00:00
 |  | 2025-01-12 00:00:00
 |  | 2025-01-13 00:00:00
 |  | 2025-01-14 00:00:00
 |  | 2025-01-15 00:00:00
 |  | 2025-01-16 00:00:00
 |  | 2025-01-17 00:00:00
 |  | 2025-01-18 00:00:00
 |  | 2025-01-19 00:00:00
 |  | 2025-01-20 00:00:00
 |  | 2025-01-21 00:00:00
 |  | 2025-01-22 00:00:00
 |  | 2025-01-23 00:00:00
 |  | 2025-01-24 00:00:00
 |  | 2025-01-25 00:00:00
 |  | 2025-01-26 00:00:00
 |  | 2025-01-27 00:00:00
 |  | 2025-01-28 00:00:00
 |  | 2025-01-29 00:00:00
 |  | 2025-01-30 00:00:00
 |  | 2025-01-31 00:00:00
 |  | 2025-02-01 00:00:00
 |  | 2025-02-02 00:00:00
 |  | 2025-02-03 00:00:00
 |  | 2025-02-04 00:00:00
 |  | 2025-02-05 00:00:00
 |  | 2025-02-06 00:00:00
 |  | 2025-02-07 00:00:00
 |  | 2025-02-08 00:00:00
 |  | 2025-02-09 00:00:00
 |  | 2025-02-10 00:00:00
 |  | 2025-02-11 00:00:00
 |  | 2025-02-12 00:00:00
 |  | 2025-02-13 00:00:00
 |  | 2025-02-14 00:00:00
 |  | 2025-02-15 00:00:00
 |  | 2025-02-16 00:00:00
 |  | 2025-02-17 00:00:00
 |  | 2025-02-18 00:00:00
 |  | 2025-02-19 00:00:00
 |  | 2025-02-20 00:00:00
 |  | 2025-02-21 00:00:00
 |  | 2025-02-22 00:00:00
 |  | 2025-02-23 00:00:00
 |  | 2025-02-24 00:00:00
 |  | 2025-02-25 00:00:00
 |  | 2025-02-26 00:00:00
 |  | 2025-02-27 00:00:00
 |  | 2025-02-28 00:00:00
 |  | 2025-03-01 00:00:00
 |  | 2025-03-02 00:00:00
 |  | 2025-03-03 00:00:00
 |  | 2025-03-04 00:00:00
 |  | 2025-03-05 00:00:00
 |  | 2025-03-06 00:00:00
 |  | 2025-03-07 00:00:00
 |  | 2025-03-08 00:00:00
 |  | 2025-03-09 00:00:00
 |  | 2025-03-10 00:00:00
 |  | 2025-03-11 00:00:00
 |  | 2025-03-12 00:00:00
 |  | 2025-03-13 00:00:00
 |  | 2025-03-14 00:00:00
 |  | 2025-03-15 00:00:00
 |  | 2025-03-16 00:00:00
 |  | 2025-03-17 00:00:00
 |  | 2025-03-18 00:00:00
 |  | 2025-03-19 00:00:00
 |  | 2025-03-20 00:00:00
 |  | 2025-03-21 00:00:00
 |  | 2025-03-22 00:00:00
 |  | 2025-03-23 00:00:00
 |  | 2025-03-24 00:00:00
 |  | 2025-03-25 00:00:00
 |  | 2025-03-26 00:00:00
 |  | 2025-03-27 00:00:00
 |  | 2025-03-28 00:00:00
 |  | 2025-03-29 00:00:00
 |  | 2025-03-30 00:00:00
 |  | 2025-03-31 00:00:00
 |  | 2025-04-01 00:00:00
 |  | 2025-04-02 00:00:00
 |  | 2025-04-03 00:00:00
 |  | 2025-04-04 00:00:00
 |  | 2025-04-05 00:00:00
 |  | 2025-04-06 00:00:00
 |  | 2025-04-07 00:00:00
 |  | 2025-04-08 00:00:00
 |  | 2025-04-09 00:00:00
 |  | 2025-04-10 00:00:00
 |  | 2025-04-11 00:00:00
 |  | 2025-04-12 00:00:00
 |  | 2025-04-13 00:00:00
 |  | 2025-04-14 00:00:00
 |  | 2025-04-15 00:00:00
 |  | 2025-04-16 00:00:00
 |  | 2025-04-17 00:00:00
 |  | 2025-04-18 00:00:00
 |  | 2025-04-19 00:00:00
 |  | 2025-04-20 00:00:00
 |  | 2025-04-21 00:00:00
 |  | 2025-04-22 00:00:00
 |  | 2025-04-23 00:00:00
 |  | 2025-04-24 00:00:00
 |  | 2025-04-25 00:00:00
 |  | 2025-04-26 00:00:00
 |  | 2025-04-27 00:00:00
 |  | 2025-04-28 00:00:00
 |  | 2025-04-29 00:00:00
 |  | 2025-04-30 00:00:00
 |  | 2025-05-01 00:00:00
 |  | 2025-05-02 00:00:00
 |  | 2025-05-03 00:00:00
 |  | 2025-05-04 00:00:00
 |  | 2025-05-05 00:00:00
 |  | 2025-05-06 00:00:00
 |  | 2025-05-07 00:00:00
 |  | 2025-05-08 00:00:00
 |  | 2025-05-09 00:00:00
 |  | 2025-05-10 00:00:00
 |  | 2025-05-11 00:00:00
 |  | 2025-05-12 00:00:00
 |  | 2025-05-13 00:00:00
 |  | 2025-05-14 00:00:00
 |  | 2025-05-15 00:00:00
 |  | 2025-05-16 00:00:00
 |  | 2025-05-17 00:00:00
 |  | 2025-05-18 00:00:00
 |  | 2025-05-19 00:00:00
 |  | 2025-05-20 00:00:00
 |  | 2025-05-21 00:00:00
 |  | 2025-05-22 00:00:00
 |  | 2025-05-23 00:00:00
 |  | 2025-05-24 00:00:00
 |  | 2025-05-25 00:00:00
 |  | 2025-05-26 00:00:00
 |  | 2025-05-27 00:00:00
 |  | 2025-05-28 00:00:00
 |  | 2025-05-29 00:00:00
 |  | 2025-05-30 00:00:00
 |  | 2025-05-31 00:00:00
 |  | 2025-06-01 00:00:00
 |  | 2025-06-02 00:00:00
 |  | 2025-06-03 00:00:00
 |  | 2025-06-04 00:00:00
 |  | 2025-06-05 00:00:00
 |  | 2025-06-06 00:00:00
 |  | 2025-06-07 00:00:00
 |  | 2025-06-08 00:00:00
 |  | 2025-06-09 00:00:00
 |  | 2025-06-10 00:00:00
 |  | 2025-06-11 00:00:00
 |  | 2025-06-12 00:00:00
 |  | 2025-06-13 00:00:00
 |  | 2025-06-14 00:00:00
 |  | 2025-06-15 00:00:00
 |  | 2025-06-16 00:00:00
 |  | 2025-06-17 00:00:00
 |  | 2025-06-18 00:00:00
 |  | 2025-06-19 00:00:00
 |  | 2025-06-20 00:00:00
 |  | 2025-06-21 00:00:00
 |  | 2025-06-22 00:00:00
 |  | 2025-06-23 00:00:00
 |  | 2025-06-24 00:00:00
 |  | 2025-06-25 00:00:00
 |  | 2025-06-26 00:00:00
 |  | 2025-06-27 00:00:00
 |  | 2025-06-28 00:00:00
 |  | 2025-06-29 00:00:00
 |  | 2025-06-30 00:00:00
 |  | 2025-07-01 00:00:00
 |  | 2025-07-02 00:00:00
 |  | 2025-07-03 00:00:00
 |  | 2025-07-04 00:00:00
 |  | 2025-07-05 00:00:00
 |  | 2025-07-06 00:00:00
 |  | 2025-07-07 00:00:00
 |  | 2025-07-08 00:00:00
 |  | 2025-07-09 00:00:00
 |  |  | Received as of
 |  | Dated | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7
 |  |  | I'm looking for suitable formula where the material recieived upto a given date is auto calculated using a formula for the cells highlighted in GREEN