Excel IF condition

[mike2080]

I am having following formulas, Based on column BW5 IF and SUMIF is brining the desired value.



=IF($BW5="No",SUMIF('Revenue Cust (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Cust (Margin Minder)'!B:B),SUMIF('Revenue Group (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Group (Margin Minder)'!B:B))



Requirement is . This whole formula should be valid only if column EU5 is "YES" . If column EU5 value is "No" then above formula should not valid.



Please advise.

[Abith]

Just Add another IF into this formula.


=IF($EU$5="YES",(IF($BW5="No",SUMIF('Revenue Cust (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Cust (Margin Minder)'!B:B),SUMIF('Revenue Group (Margin Minder)'!$BN:$BN,'Main Data'!$EN5,'Revenue Group (Margin Minder)'!B:B))),"Not Applicable")