Hi guys,
Excel novice here looking for some help with the SUMIFS formula.
I need to be able to compare the loan amount against the date, along with the other data I've included in the below (uncompleted) formula.
=SUMIFS(D:D, E:E, "Accept", F:F, "Post", C:C, "Car Loan"
I don't want to specify a specific loan amount. I just want to see the amounts that have been applied for and on what dates.
I've attached the spreadsheet for reference. Any help would be really appreciated.
Charlie
Bookmarks