• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    How to lookup a value across multiple sheets and return sheet names [SOLVED]

    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...
  2. P

    SumProduct with changing criteria [SOLVED]

    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%...
  3. P

    Sumproduct with changing criteria

    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% |...
  4. P

    Sumproduct query

    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)...
Back
Top