Forum Discussion
Sum 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 ...
Hi Kelsey,
I've updated your workbook with the solution, hope you find it helpful.
You can use either https://support.office.com/en-us/article/SUMIF-function-169B8C99-C05C-4483-A712-1697A653039B or https://support.office.com/en-us/article/SUMIFS-function-C9E748F5-7EA7-455D-9406-611CEBCE642B.
This is the formula in column August:
=SUMIFS('Checking Account - August'!C:C,'Checking Account - August'!D:D,A2)
Regards,
Haytham