Spreadsheet: 873939d1720536185-sum-quarterly-and-yearly-from-vlookup-dynamic-array-result-dynamic-sum-quarterly-and-yearly-ans
Sheet: Sheet1

 |  |  |  |  | Lookup "Date" Array | [NAME] | Desired Result via Dynamic Array |  |  | Date | Amount
45444 |  | 2024-06-01 00:00:00 | 56 |  |  |  | 56 |  |  |  | 56 |  | =LET(a,K2:[NAME],L2:L26,BYROW(F2:F35,LAMBDA(x,IF(LEFT(x,1)="Q",SUM(OFFSET(INDEX(b,MATCH(OFFSET(x,-1,0),a,0)),0,0,-3)),IF(LEFT(x,1)="F",SUM(OFFSET(INDEX(b,MATCH(OFFSET(x,-2,0),a,0)),0,0,-12)),INDEX(b,MATCH(x,a,0)))))))
45474 |  | 2024-07-01 00:00:00 | 49 |  | 2024-07-01 00:00:00 |  | 49 |  |  | 2024-07-01 00:00:00 | 49
45505 |  | 2024-08-01 00:00:00 | 74 |  | 2024-08-01 00:00:00 |  | 74 |  |  | 2024-08-01 00:00:00 | 74
Q1FY25 Total |  | 2024-09-01 00:00:00 | 27 |  | Q1FY25 Total |  |  |  |  | 2024-09-01 00:00:00 | 27
45536 |  | 2024-10-01 00:00:00 | 51 |  | 2024-09-01 00:00:00 |  | 27 |  |  | 2024-10-01 00:00:00 | 51
45566 |  | 2024-11-01 00:00:00 | 82 |  | 2024-10-01 00:00:00 |  | 51 |  |  | 2024-11-01 00:00:00 | 82
45597 |  | 2024-12-01 00:00:00 | 58 |  | 2024-11-01 00:00:00 |  | 82 |  |  | 2024-12-01 00:00:00 | 58
Q2FY25 Total |  | 2025-01-01 00:00:00 | 62 |  | Q2FY25 Total |  |  |  |  | 2025-01-01 00:00:00 | 62
45627 |  | 2025-02-01 00:00:00 | 85 |  | 2024-12-01 00:00:00 |  | 58 |  |  | 2025-02-01 00:00:00 | 85
45658 |  | 2025-03-01 00:00:00 | 103 |  | 2025-01-01 00:00:00 |  | 62 |  |  | 2025-03-01 00:00:00 | 103
45689 |  | 2025-04-01 00:00:00 | 129 |  | 2025-02-01 00:00:00 |  | 85 |  |  | 2025-04-01 00:00:00 | 129
Q3FY25 Total |  | 2025-05-01 00:00:00 | 118 |  | Q3FY25 Total |  |  |  |  | 2025-05-01 00:00:00 | 118
45717 |  | 2025-06-01 00:00:00 | 18 |  | 2025-03-01 00:00:00 |  | 103 |  |  | 2025-06-01 00:00:00 | 18
45748 |  | 2025-07-01 00:00:00 | 17 |  | 2025-04-01 00:00:00 |  | 129 |  |  | 2025-07-01 00:00:00 | 17
45778 |  | 2025-08-01 00:00:00 | 49 |  | 2025-05-01 00:00:00 |  | 118 |  |  | 2025-08-01 00:00:00 | 49
Q4FY25 Total |  | 2025-09-01 00:00:00 | 82 |  | Q4FY25 Total |  |  |  |  | 2025-09-01 00:00:00 | 82
FY25 Total |  | 2025-10-01 00:00:00 | 84 |  | FY25 Total |  |  |  |  | 2025-10-01 00:00:00 | 84
45809 |  | 2025-11-01 00:00:00 | 30 |  | 2025-06-01 00:00:00 |  | 18 |  |  | 2025-11-01 00:00:00 | 30
45839 |  | 2025-12-01 00:00:00 | 78 |  | 2025-07-01 00:00:00 |  | 17 |  |  | 2025-12-01 00:00:00 | 78
45870 |  | 2026-01-01 00:00:00 | 87 |  | 2025-08-01 00:00:00 |  | 49 |  |  | 2026-01-01 00:00:00 | 87
Q1FY26 Total |  | 2026-02-01 00:00:00 | 73 |  | Q1FY26 Total |  |  |  |  | 2026-02-01 00:00:00 | 73
45901 |  | 2026-03-01 00:00:00 | 141 |  | 2025-09-01 00:00:00 |  | 82 |  |  | 2026-03-01 00:00:00 | 141
45931 |  | 2026-04-01 00:00:00 | 118 |  | 2025-10-01 00:00:00 |  | 84 |  |  | 2026-04-01 00:00:00 | 118
45962 |  | 2026-05-01 00:00:00 | 102 |  | 2025-11-01 00:00:00 |  | 30 |  |  | 2026-05-01 00:00:00 | 102
Q2FY26 Total |  | 2026-06-01 00:00:00 | 120 |  | Q2FY26 Total |  |  |  |  | 2026-06-01 00:00:00 | 120
45992 |  |  |  |  | 2025-12-01 00:00:00 |  | 78
46023 |  |  |  |  | 2026-01-01 00:00:00 |  | 87
46054 |  |  |  |  | 2026-02-01 00:00:00 |  | 73
Q3FY26 Total |  |  |  |  | Q3FY26 Total
46082 |  |  |  |  | 2026-03-01 00:00:00 |  | 141
46113 |  |  |  |  | 2026-04-01 00:00:00 |  | 118
46143 |  |  |  |  | 2026-05-01 00:00:00 |  | 102
[NAME] |  |  |  |  | [NAME]
FY26 Total |  |  |  |  | FY26 Total