Spreadsheet: 823580d1680020390-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-sample
Sheet: Budget

 |  | FORECAST | ACTUALS
 | 2023-01-01 00:00:00 |  | 6
 | 2023-02-01 00:00:00 | 1500 | 1000
 | 2023-03-01 00:00:00 | 0 | 500
 | 2023-04-01 00:00:00 | 3700 | 3700
 | 2023-05-01 00:00:00 | 0 | 0
 | 2023-06-01 00:00:00 | 1500 | 500
 | 2023-07-01 00:00:00 | 0 | 500
 | 2023-08-01 00:00:00 | 1000 | 0
 | 2023-09-01 00:00:00 | 8800 | 8500
 | 2023-10-01 00:00:00 | 8000 | 7800
 | 2023-11-01 00:00:00 | 0 | 0
 | 2023-12-01 00:00:00 | 0 | 0
 | 2024-01-01 00:00:00 | 617000 | 617000
 | 2024-02-01 00:00:00 | 0 | 0
 | 2024-03-01 00:00:00 | 0 | 0
 | 2024-04-01 00:00:00 | 0 | 0
 | 2024-05-01 00:00:00 | 0 | 0
 | 2024-06-01 00:00:00 | 0 | 0
 | 2024-07-01 00:00:00 | 0 | 0
 | 2024-08-01 00:00:00 | 0 | 0
 | 2024-09-01 00:00:00 | 0 | 0
 | 2024-10-01 00:00:00 | 0 | 0
 | 2024-11-01 00:00:00 | 0 | 0
 | 2024-12-01 00:00:00 | 0 | 0
 | internal charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICES
 | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2023-04-01 00:00:00 |  | 2023-05-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS
 | 1 | 2 | 500 | 500 |  |  | 2000 | 2000 |  |  | 1000 | 500 |  |  | 1000 |  |  |  | 8000 | 7800
 | external charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICES
 | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2023-04-01 00:00:00 |  | 2023-05-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS
 | 3 | 4 | 1000 | 500 |  | 500 | 1700 | 1700 |  |  | 500 |  |  | 500 |  |  | 8800 | 8500