Forum Discussion
Dependent (secondary) drop down lists
I have a budget tracker. once i record an expense, I have drop down list for the categories they fall into. however, once I select the drop down menu, I want the amounts to automatically sum into the listed categories on the right hand side that shows the budget for each category and the running total and the remaining left. How do I do this!!! HELP PLEASE!!!
Rick
Hi Rick,
you can use SUMIFS function to calculate running totals from the 'Expenses' table against the listed categories. Assuming you record your expenses in a table named tblActuals, which has two columns being 'Category' and 'Expense', and you have a budget table, which lists categories in a 'Category' column, your formula in the 'Running Total' column of the budget table would be
=SUMIFS(tblActuals[Expense],tblActuals[Category],[@Category]).
Please find an example attached.
Yury