Forum Discussion
gather data in different worksheets
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 ta...
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)))