Forum Discussion
Solved
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 ...
KyleWalts Pivot table would do the task for you. Additionally you can use traditional SUMIFS() function like (as per my below screenshot.
=SUMIFS($B$2:$B$16,$A$2:$A$16,H2)With Microsoft-365 dynamic formulas, you can do these all in one go. Try-
=VSTACK(A1:B1,UNIQUE(HSTACK(A2:A16,SUMIFS(B2:B16,A2:A16,A2:A16))))Download the attached file for better understanding.
Use a pivot table or SUMIF().
- Convert the Spreadsheet to table first. Next Pivot the table with category as row and amount in formulaes. It would better to add another column for the date or month and year which can add benefit to track expenses monthly and yearly.
