Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Jul 05, 2022

SUMIFS function return 0 value

Hi @All, In DL Phạt sheet ,I have an issue with SUMIFS function, which return 0 value while SUMIF funcion return right value(140) I have added an image and link of sample file below Hope for your ...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 05, 2022

littlevillage Be aware that the criteria in SUMIFS work as an AND function. All criteria must be met. No number in the sum_range will ever be in a column headed by both values in DV4 and DW4. Hence, zero!

 

A SUMIF for numbers that are headed by "DV4" plus a SUMIF for numbers headed by "DW4" will give the answer you want to see, though. I suspect that's what you have done.

 

 

  • littlevillage's avatar
    littlevillage
    Iron Contributor
    Jul 06, 2022

    Riny_van_Eekelen 

    I have tried to do the same that your mentioned, but It's still not work

    I have added a link of the sample file below

    Can you make some notes on the formula?

    https://docs.google.com/spreadsheets/d/1WGEfLNTkhIEehMSlZHLfxQZIVk0JQsx0/edit?usp=sharing&ouid=112310544159929632856&rtpof=true&sd=true 

     

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jul 06, 2022

      littlevillage As said, you can't use SUMIFS in this case in DZ9. You need to use SUMIF the way you have done in DZ5. But perhaps I misunderstand your intentions.

Resources