I did a search on the forum and couldn't find a solution.
I have Employee Names across multiple sheets with each sheet representing a Division (sheet name).
I also have an input sheet where I have a list of all Employees. In the input sheet I want a quick way to identify which...
Hi
I want to be able to run a SUMPRODUCT formula for changing criteria.
I have different department codes for employees, example below.
Dept Employee Salary Proportion Effort for Product A Effort for Product B
100 Jim 10% 70% 30%
100 Bill 20% 20% 80%
200 Peter 60% 30%...
Hi
I wanted to use the sumproduct formula but with the ability to recognise when the criteria changed.
See Example below.
I'm using | as column separators.
Cost Centre | Employee | Employee% | Employee Effort
100 | Bob | 50% | 30%
100 | Jim | 50% |...
I am having problems with my Sumproduct formula.
If I type the following, it returns a value correctly.
=SUMPRODUCT(($L$5:$DS$5=D$1434)*($I$7:$I$50=$B1441),$L$7:$DS$50)
If I increase the data range, it returns a #N/A error.
=SUMPRODUCT(($L$5:$DS$5=D$1434)*($I$7:$I$500=$B1441),$L$7:$DS$500)...