Hello,

Is there any formula (SUMIF, SUMPRODUCT, SUMIFS etc..) to sum both horizontal and vertical with different criteria? I want to summarize how many hours a week (22-24) each employee (Name X-Z) are working. The result i want is shown in the summary table below, typed in manualy).


Excel.jpg