Home

Sum of Drop down Lists

KelseyOdey
Occasional Visitor

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 excel to sum all the expenses based on their category.  I keep trying to use the SUMIF function, but for sum reason it is not working for categories that I have multiple expenses under.  Please see my attached file.

 

I want the totals from the monthly transactions to go into the corresponding month on the first worksheet.

1 Reply
Highlighted

Hi 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,

Haytham

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies