Forum Discussion

Jo_Parker's avatar
Jo_Parker
Copper Contributor
Mar 23, 2022
Solved

SumProduct not returning correct value

Hi

I have a sumproduct that is looking across different tabs in one sheet, but it is not calculating the correct values.

 

This is the sum:

=SUMPRODUCT((to13thmar!$G$8:$G$186=$B22:$G22)*to13thmar!$X$8:$X$186)

 

It should return 3 and is returning 2. 

 

excel
Formulas and Functions
  • Jo_Parker's avatar
    Jo_Parker
    Mar 23, 2022

    HiDonald_Genes 

     

    I found the Issue. I had spaces before some of my numbers so after removing these the formula calculates properly.

    thanks

     

3 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 23, 2022

    Jo_Parker 

    Could you attach a sample workbook demonstrating the problem (without sensitive data), or make it available through OneDrive, Google Drive, Dropbox or similar?

  • Donald_Genes's avatar
    Donald_Genes
    Brass Contributor
    Mar 23, 2022
    why not consolidate all the worksheet into one and run your sumproduct?
    • Jo_Parker's avatar
      Jo_Parker
      Copper Contributor
      Mar 23, 2022

      HiDonald_Genes 

       

      I found the Issue. I had spaces before some of my numbers so after removing these the formula calculates properly.

      thanks

       

Resources