Excel IF

[Micro440]

Team,

I have following formulas, Based on column BW5 result the output is displaying. 

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

[#2 · Accepted solution]

@Micro440 

Try

=IF($EU5="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)),"")

[#3]

Thank you