I'm trying to SUM the hours of employees. The list is sorted by WE date and name.
The employees name is in U3. I tried multiple variations of:
The arrayformula only returns the sum of values from the first line SUMIF returns 0
Here is what the data look like: