Forum Discussion

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Oct 06, 2016

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 Coffe...
Formulas & Functions
tips and tricks
rickmichaels72's avatar
rickmichaels72
Copper Contributor
May 16, 2017

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

Yury Tokarev's avatar
Yury Tokarev
Iron Contributor
May 16, 2017

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

Resources