SOLVED

Excel IF

Occasional Contributor

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 Replies
best response confirmed by Micro440 (Occasional Contributor)
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)),"")

Thank you