Forum Discussion
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 ...
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
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.