seriousdamage
Board Regular
- Joined
- Aug 14, 2005
- Messages
- 58
Hello,
I making a finance tracking file,
Tab 1 - Summary - An overview that will change based on the selection I make
Tab 2 - Details - List of every invoices with Period name (October 2018) and Tax code like "xxx" and Invoice amount
Tab 3 - Data - So far just a list of Periods that a dropdown list will pick up
On the summary file in cell A1 I made a drop down list referencing to the Period list in Tab 3
In cell A2 I would like to have the sum of all invoices amounts with tax code XXX for the selected period
I can do this if I only had to select the tax code, but I cannot build it if I need to select also an item from the drop down list.
Could someone give me some guidance?
Much appreciated
Best regards
Nic
I making a finance tracking file,
Tab 1 - Summary - An overview that will change based on the selection I make
Tab 2 - Details - List of every invoices with Period name (October 2018) and Tax code like "xxx" and Invoice amount
Tab 3 - Data - So far just a list of Periods that a dropdown list will pick up
On the summary file in cell A1 I made a drop down list referencing to the Period list in Tab 3
In cell A2 I would like to have the sum of all invoices amounts with tax code XXX for the selected period
I can do this if I only had to select the tax code, but I cannot build it if I need to select also an item from the drop down list.
Could someone give me some guidance?
Much appreciated
Best regards
Nic