Apr 05 2019 09:27 PM
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
Apr 06 2019 04:19 AM
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)))
Apr 06 2019 05:55 AM
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