The following is a simplified version of my problem.
I got a table in which I list whether an employee was working on that specific project or not. So the columns are calendar-week, date, day-of-week, name and the rows are the current week, the date, the day and a simple 1 if that employee was working or not.
A B C D F CW Date Day Employee1 Employee2 31 01.08.18 Wed 1 31 02.08.18 Thu 1 1
Now I wanna assemble a second table that gives me the numbers per week:
A B C D CW Year Employee1 Employee2 31 2018 2 1
I tried using
COUNTIF but can't get it working. Here's an example for Employee1:
=COUNTIF(Table1!D:D; AND(YEAR(Table1!B:B)=Table2!B; Table1!A:A=Table2!A)
So, it should sum/count the occurrences of 1 in column D (employee 1) if the year is 2018 and the calendar week is 31. What am I doing wrong?