Nov 21 2021 09:02 PM
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.
Nov 22 2021 03:40 AM - edited Nov 22 2021 03:40 AM
SolutionTry
=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)),"")
Nov 22 2021 03:40 AM - edited Nov 22 2021 03:40 AM
SolutionTry
=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)),"")