gather data in different worksheets

[Ramon Haagen]

Hello,

I attached a file to make it easier to explain and hopefully to find a solution.

In the file there is a tab individual performance and working hours. I would like to gather from the tab working hour in the tab individual performance the amount of hours worked in that week per person. how can I do this?

password of file is 1234

[#2]

Hi @Ramon Haagen ,

It could be

=SUMIF(Working_Hours__2[[WEEK]:[WEEK]],$CB5,INDEX(Working_Hours__2,,MATCH(CC$4,Working_Hours__2[#Headers],0)))

[#3]

@Ramon Haagen 

I prepared two files for you.

V2 file: using formula "AVERAGEIFS" to do the averaging. But it requires that the columns for person are correspondence. 

V3 file: change the structure of the data and then using a pivot table to demonstrate