Forum Discussion
Dependent (secondary) drop down lists
I've recently seen a few posts on various sites with people requiring assistance in devloping dependent drop downs.
- For example drop down box A contains Tea, Coffe, Juice
- If you select Coffee then drop down box B should show Flat White, Cappuccino etc
Here's my demo file: https://doc.co/QGgAxp
Hope it helps
3 Replies
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
- I have created several tutorials on this topic which can be found here - http://www.contextures.com/excelfilesRoger.html For those with XL2007 upward, I would recommend the use of Tables see DV004 and DV005 For earlier versions (and working in all versions of Excel) there are examples using named ranges with Index see DV002 and DV003
