Hello Everyone,
I am using sumif function to calculate an amount based on criteria (A2:D2) but whenever there is a blank cell in the Region column the result turns to be "Zero". I am thinking if we can skip the blank cell to get the result.
I tried the "*" and "<>" but ends up with too many arguments or #Value .
<tbody> </tbody>
I am using sumif function to calculate an amount based on criteria (A2:D2) but whenever there is a blank cell in the Region column the result turns to be "Zero". I am thinking if we can skip the blank cell to get the result.
I tried the "*" and "<>" but ends up with too many arguments or #Value .
A | B | C | D | E | F | |
1 | Name | Type | Resource | Region | Quantity | Amount |
2 | AAA | 123 | US | 100 | =SUMIFS('EA Report'!$L:$L,'EA Report'!$C:$C,Play!$A2,'EA Report'!$D:$D,Play!$C2,'EA Report'!$J:$J,Play!D2) | |
3 | BBB | 456 | UK | 50 | ||
4 | GGG | 456 | 125 | Blank or Zero |
<tbody> </tbody>