User Profile
KyleWalts
Copper Contributor
Joined Aug 08, 2023
User Widgets
Recent Discussions
How do I auto-populate an amount value based off a category drop down list into a cell?
Hello. Looking for some help here with a formula. I started a spreadsheet to help me track every expense, keep track of my budget, etc. On one tab I have a running log of all my transactions for the month. Each transaction I have it categorized via a drop down list such as Bills, Essentials, Gas, Eating Out, etc. Then to the right of that column I have the amount of that transaction. On the 2nd tab I have a summary table for each item in the category drop down list(Bills, Essentials, Gas, Eating Out, etc.). What I would like to happen is when I add transactions and I label them a specific category, I would like on the other tab in my summary table to keep a running total amount of each transaction in that specific category. For example: Let's say I added 4 new transactions and I have them labeled under Bills and each bill was worth $25. I would like the "Bills" row on my other tab to automatically add those 4 "Bills" totals and have $100 in that specific cell next to "Bills" under the Actual column in my picture. I have added 2 pictures. If anyone could help out, that would be fantastic! If you would like me to add any more photos or if I can attach the spreadsheet itself, I wouldn't mind. Just let me know! Thanks, Kyle
