Excel analyse data from two tab

New Contributor

Hello everyone,


I have data from 2 tabs in the same excel file. I would like to make a some in function of the value in one column.


I have different area with the same thickness and I have to have automatically the sum per thickness (esay with every thing one tab by pivot table but I am totally out with 2 tabs)


explanation i want to sum total area and equivalent area per thickness and per material.





What can be your solution ? 


Thank you very much all



2 Replies

Hi @Jordan_atg 


my proposal would be to load both source tables to Power Query, combine them and then create a Pivot table from this combined table 

Thank you, @Martin_Weiss 


Sorry to behind late, I don't this complement of excel. I will try to add it. And test our proposition