Jul 04 2022 08:35 PM - edited Jul 04 2022 09:32 PM
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
Jul 04 2022 08:59 PM
@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.
Jul 06 2022 01:40 AM - edited Jul 06 2022 01:41 AM
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?
Jul 06 2022 01:54 AM
@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.