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 advising

Thanks

small_village 

 

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

Formulas and Functions

3 Replies

  • 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