Dec 21 2020 03:48 AM
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?
Dec 21 2020 04:50 AM
@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!