I'm creating a budget that is to track the daily bank balances based on recurring transactions as well as one off transactions. The recurring transactions sum if the day of the months match and the one offs sum if the dates match exatcly.
What I want to do is sum the values until the payment's last date, which is input in the transaction tracker sheet (column 'Last Payment').
The workbook has the sumifs in the daily balance sheet and the transactions in the transaction tracker sheet.
Any help is greatly appreciated! Thank you!