Forum Discussion
Data formula
Hi!
Hello! I want to create a complex formula and wonder how you solved it.
In the excel sheet for investments, I have added a department and a person who is responsible for each purchase.
Each year is divided into one tab. 2021-2026.
On my first page I have statistics.
What I want to do is have three list boxes where I can choose the department and / or person responsible and years to get a sum for the different combinations.
How would you proceed?
3 Replies
Victor_Svensson May I suggest that you collect all your data in one table and summarise it to your liking with the help of one or more pivot tables? I added an example to your file in the sheet called "PivotTable".
God Jul!
Thanks! I Will check this out!
