Spreadsheet: 873879d1720459641-sum-quarterly-and-yearly-from-vlookup-dynamic-array-result-dynamic-sum-quarterly-and-yearly
Sheet: Sheet1

 |  |  |  |  | Lookup "Date" Array | [NAME] (Dynamic) | Desired Result via Dynamic Array |  |  | Date | Amount
45444 |  | 2024-06-01 00:00:00 | 56 |  |  |  | 56 |  |  |  | 56
45474 |  | 2024-07-01 00:00:00 | 49 |  | 2024-07-01 00:00:00 | 49 | 49 |  |  | 2024-07-01 00:00:00 | 49
45505 |  | 2024-08-01 00:00:00 | 74 |  | 2024-08-01 00:00:00 | 74 | 74 |  |  | 2024-08-01 00:00:00 | 74
Q1FY25 Total |  | 2024-09-01 00:00:00 | 27 |  | Q1FY25 Total | #N/A |  |  |  | 2024-09-01 00:00:00 | 27
45536 |  | 2024-10-01 00:00:00 | 51 |  | 2024-09-01 00:00:00 | 27 | 27 |  |  | 2024-10-01 00:00:00 | 51
45566 |  | 2024-11-01 00:00:00 | 82 |  | 2024-10-01 00:00:00 | 51 | 51 |  |  | 2024-11-01 00:00:00 | 82
45597 |  | 2024-12-01 00:00:00 | 58 |  | 2024-11-01 00:00:00 | 82 | 82 |  |  | 2024-12-01 00:00:00 | 58
Q2FY25 Total |  | 2025-01-01 00:00:00 | 62 |  | Q2FY25 Total | #N/A |  |  |  | 2025-01-01 00:00:00 | 62
45627 |  | 2025-02-01 00:00:00 | 85 |  | 2024-12-01 00:00:00 | 58 | 58 |  |  | 2025-02-01 00:00:00 | 85
45658 |  | 2025-03-01 00:00:00 | 103 |  | 2025-01-01 00:00:00 | 62 | 62 |  |  | 2025-03-01 00:00:00 | 103
45689 |  | 2025-04-01 00:00:00 | 129 |  | 2025-02-01 00:00:00 | 85 | 85 |  |  | 2025-04-01 00:00:00 | 129
Q3FY25 Total |  | 2025-05-01 00:00:00 | 118 |  | Q3FY25 Total | #N/A |  |  |  | 2025-05-01 00:00:00 | 118
45717 |  | 2025-06-01 00:00:00 | 18 |  | 2025-03-01 00:00:00 | 103 | 103 |  |  | 2025-06-01 00:00:00 | 18
45748 |  | 2025-07-01 00:00:00 | 17 |  | 2025-04-01 00:00:00 | 129 | 129 |  |  | 2025-07-01 00:00:00 | 17
45778 |  | 2025-08-01 00:00:00 | 49 |  | 2025-05-01 00:00:00 | 118 | 118 |  |  | 2025-08-01 00:00:00 | 49
Q4FY25 Total |  | 2025-09-01 00:00:00 | 82 |  | Q4FY25 Total | #N/A |  |  |  | 2025-09-01 00:00:00 | 82
FY25 Total |  | 2025-10-01 00:00:00 | 84 |  | FY25 Total | #N/A |  |  |  | 2025-10-01 00:00:00 | 84
45809 |  | 2025-11-01 00:00:00 | 30 |  | 2025-06-01 00:00:00 | 18 | 18 |  |  | 2025-11-01 00:00:00 | 30
45839 |  | 2025-12-01 00:00:00 | 78 |  | 2025-07-01 00:00:00 | 17 | 17 |  |  | 2025-12-01 00:00:00 | 78
45870 |  | 2026-01-01 00:00:00 | 87 |  | 2025-08-01 00:00:00 | 49 | 49 |  |  | 2026-01-01 00:00:00 | 87
Q1FY26 Total |  | 2026-02-01 00:00:00 | 73 |  | Q1FY26 Total | #N/A |  |  |  | 2026-02-01 00:00:00 | 73
45901 |  | 2026-03-01 00:00:00 | 141 |  | 2025-09-01 00:00:00 | 82 | 82 |  |  | 2026-03-01 00:00:00 | 141
45931 |  | 2026-04-01 00:00:00 | 118 |  | 2025-10-01 00:00:00 | 84 | 84 |  |  | 2026-04-01 00:00:00 | 118
45962 |  | 2026-05-01 00:00:00 | 102 |  | 2025-11-01 00:00:00 | 30 | 30 |  |  | 2026-05-01 00:00:00 | 102
Q2FY26 Total |  | 2026-06-01 00:00:00 | 120 |  | Q2FY26 Total | #N/A |  |  |  | 2026-06-01 00:00:00 | 120
45992 |  |  |  |  | 2025-12-01 00:00:00 | 78 | 78
46023 |  |  |  |  | 2026-01-01 00:00:00 | 87 | 87
46054 |  |  |  |  | 2026-02-01 00:00:00 | 73 | 73
Q3FY26 Total |  |  |  |  | Q3FY26 Total | #N/A
46082 |  |  |  |  | 2026-03-01 00:00:00 | 141 | 141
46113 |  |  |  |  | 2026-04-01 00:00:00 | 118 | 118
46143 |  |  |  |  | 2026-05-01 00:00:00 | 102 | 102
[NAME] |  |  |  |  | [NAME] | #N/A
FY26 Total |  |  |  |  | FY26 Total | #N/A