Spreadsheet: 776035d1649447024-maxifs-function-not-working-anymore-currently-returns-0-test-dashboard2
Sheet: SUBSCRIPTIONS

CID | STATUS | BILL NUMBER | BILL YEAR | BILL QUARTER | START | END | FIXED | RECURRING | TOTAL HTVA | TOTAL TVAC | STATUS | COMMENTS
 | Billed | 2022-006 |  |  | 2022-04-01 00:00:00 |  | 2999 |  |  |  | to receive | website creation
 | Billed | 2022-006 |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Billed | 2022-006 |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | domain name registration
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | domain name renewal
 | Billed | 2022-004 |  |  | 2022-02-01 00:00:00 |  | 2999 |  |  |  | received | website creation
 | Billed | 2022-004 |  |  | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  | 100 |  |  | to receive | last year's automatic translations
 | Billed | 2022-003 |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | canceled | domain name registration
 | Billed | 2022-002 |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | received | domain name registration
 | Billed | 2022-001 |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | canceled | domain name registration
 | Billed | 2021-007 |  |  | 2021-12-01 00:00:00 |  | 1599 |  |  |  | received | website creation
 | Billed | 2021-008 |  |  | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Billed | 2021-008 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Billed | 2021-008 |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Billed | 2021-008 |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Billed | 2021-005 |  |  | 2021-10-01 00:00:00 |  | 500 |  |  |  | received | website creation
 | Billed | 2021-006 |  |  | 2021-10-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Billed | 2021-003 |  |  | 2021-07-01 00:00:00 |  |  |  |  |  | received | website creation
 | Billed | 2021-004 |  |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Billed | 2022-007 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Billed | 2021-001 |  |  | 2021-07-01 00:00:00 |  |  |  |  |  | received | website creation
 | Billed | 2021-002 |  |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Billed | 2022-005 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | received | website maintenance
 | Forecast |  |  | Q1 | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | to receive | website maintenance
 | Forecast |  |  | Q1 | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | to receive | website maintenance