Spreadsheet: 881001d1728903942-sum-interest-per-quarter-summing-interest
Sheet: Sheet1

 | I am kindly requesting a formula to calculate to sum interest on tax per respective quarter, as show on the desired solution.
 | I kindly request assistance with creating a formula to calculate the quarterly interest, as illustrated in the desired solution.
 |  |  |  |  |  |  | Desired solution
 | Transaction Date | Transaction Description | Document Reference Number | ZWG |  |  |  | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
 | 2024-06-27 00:00:00 | ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 1st Quarter | Ei227062024008759 | 85941.32 |  |  | Interest | 984.27 | 2527.76 | 3033.09 | 3540.05
 | 2024-06-27 00:00:00 | ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 2nd Quarter | Ei227062024008759 | 214853.31
 | 2024-06-27 00:00:00 | ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 3rd Quarter | Ei227062024008759 | 257823.97
 | 2024-06-27 00:00:00 | ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 4th Quarter | Ei227062024008759 | 300794.63
 | 2024-06-27 00:00:00 | ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 1st Quarter | Ei227062024008759 | 2578.24
 | 2024-06-27 00:00:00 | ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 2nd Quarter | Ei227062024008759 | 6445.6
 | 2024-06-27 00:00:00 | ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 3rd Quarter | Ei227062024008759 | 7734.72
 | 2024-06-27 00:00:00 | ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 4th Quarter | Ei227062024008759 | 9023.84
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 1st Quarter | Ei227062024008759 | 727.36
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 2nd Quarter | Ei227062024008759 | 1882.88
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 3rd Quarter | Ei227062024008759 | 2259.36
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 4th Quarter | Ei227062024008759 | 2636.96
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 1st Quarter | Ei227062024008759 | 22.56
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 2nd Quarter | Ei227062024008759 | 56.48
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 3rd Quarter | Ei227062024008759 | 67.68
 | 2024-06-27 00:00:00 | Calculated interest on ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 4th Quarter | Ei227062024008759 | 79.04
 | 2024-07-02 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 1st Quarter | Ei227062024008759 | 227.3
 | 2024-07-02 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 2nd Quarter | Ei227062024008759 | 588.4
 | 2024-07-02 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 3rd Quarter | Ei227062024008759 | 706.05
 | 2024-07-02 00:00:00 | Calculated interest on ZWG debit from, INCOME, Income Tax Self Assessment Return - Business, [NAME], 2023, 4th Quarter | Ei227062024008759 | 824.05
 | 2024-07-02 00:00:00 | Calculated interest on ZWG debit from, AIDS, Income Tax Self Assessment Return - Business, [NAME], 2023, 1st Quarter | Ei227062024008759 | 7.05