SUMIFS function return 0 value

[littlevillage]

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=11231... 

[#2]

@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.

[#3]

@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=11231... 

[#4]

@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.