Data formula

[Victor_Svensson]

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?

[#2]

@Victor_Svensson 

[#3]

@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!

[#4]

Thanks! I Will check this out!