Happy New Year everyone.
I'm working on a spreadsheet designed to track my personal finances on a weekly basis. See the attached file. I want the formula to look at the master list of transactions on the left side of the spreadsheet and display the total debit amount for a particular category if it is within a specific date range. I'm using the array formula {=SUM(($A$2:$A$16<=I$5)*($B$2:$B$16="Mortgage")*($D$2:$D$16))} but I can't get it to look at only the date range that corresponds to the specific week.
I'm open to using other formulas if there is something else that will work but in my research the array formula seemed to be the best suited. Any help would be much appreciated and if you need clarification feel free to message me back.
Thanks,
Bookmarks