Spreadsheet: 714528d1611256691-help-computing-a-running-total-between-2-sheets-book6-1-
Sheet: delivery schedule

 |  |  |  | Date |  | Incoming Weight
 |  | PO | Line | 2021-01-25 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-01-25 00:00:00 | 15:00:00 | 45000 | Status |  | This is the schedule, I assume some sort of VLOOKUP formula needs to be done utilizing Columns C and E
 |  | PO | Line | 2021-01-26 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-01-26 00:00:00 | 15:00:00 | 45000 | Status |  | I want to take the incoming weight, and have it added to the running total on the previous sheet
 |  | PO | Line | 2021-01-27 00:00:00 | 15:00:00 | 0 | Status
 |  | PO | Line | 2021-01-27 00:00:00 | 10:00:00 | 45000 | Status |  | Example: The previous sheet shows a starting of 200,000. Then on Monday we are using a total of 82,204 between both production lines; but on Monday we also have an incoming qty of 90,000
 |  | PO | Line | 2021-01-27 00:00:00 | 15:00:00 | 45000 | Status |  | (See Rows 4 and 5)
 |  | PO | Line | 2021-01-28 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-01-28 00:00:00 | 15:00:00 | 45000 | Status |  | How can I set up the VLOOKUP to add the weight on the 1st page based on the dates and qtys on the 2nd?
 |  | PO | Line | 2021-01-29 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-01-29 00:00:00 | 15:00:00 | 45000 | Status |  | The schedule is a running schedule that starts back in 2019, and goes on forever.
 |  | PO | Line | 2021-01-30 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-01-30 00:00:00 | 15:00:00 | 45000 | Status
 |  | PO | Line | 2021-01-31 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-01 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-01 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-02 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-02 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-03 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-03 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-04 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-04 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-05 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-05 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-06 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-06 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-07 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-08 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-08 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-09 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-09 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-10 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-10 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-11 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-11 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-12 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-12 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-13 00:00:00 | 10:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-13 00:00:00 | 13:00:00 | 45000 | Status
 |  | PO | Line | 2021-02-14 00:00:00 | 10:00:00 | 45000 | Status