Help with Excel formula needed!
I want to calculate percentage of normal workload for a number of resources. The percentage should be calculated using a normal workload for each month and actual for each month and resource. See example file!
Zero in cell means that resource didn't work at all, and empty cell means that I just didn't fill in value yet so that month shouldn't be included.
The percentage shown in col H should be the total per resource. For example for Name 1, 62% (hardcoded in file).
The trick for me is that I only want to include cells with value in rows 5 - 7 and corresponding normal values in row 10. Remember that zero is a value!