Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
KelseyOdeyCopper ContributorJan 12, 2019Sum of Drop down Lists I have created a list of categories for a budget. Then on another worksheet I have all my checking account transactions. I already created the drop down list to categorize the expense. Now I want ...Show More2018 August - October Checkign Acct Activity.xlsx41 KB
Haytham AmairahSilver ContributorJan 12, 2019Hi Kelsey, I've updated your workbook with the solution, hope you find it helpful.You can use either SUMIF or SUMIFS. This is the formula in column August:=SUMIFS('Checking Account - August'!C:C,'Checking Account - August'!D:D,A2) Regards,Haytham2018 August - October Checkign Acct Activity (Solved).xlsx17 KB
