Spreadsheet: 823394d1679942273-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-sample-3-sumifs
Sheet: Budget

 |  | FORECAST | ACTUALS
 | 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
 | internal charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICES
 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-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
 |  |  | 500 | 500 |  |  | 2000 | 2000 |  |  | 1000 | 500 |  |  | 1000 |  |  |  | 8000 | 7800
 | external charges |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICES
 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-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
 |  |  | 1000 | 500 |  | 500 | 1700 | 1700 |  |  | 500 |  |  | 500 |  |  | 8800 | 8500