Why doesn't this formula work:
=SUMPRODUCT(SIGN((njdata[StoreType]={"SIS","SIS M","SIS L","SIS P"})*(njdata[Season]={"AW16","SS16","AW15"}))*njdata[revenue])
When this one does:
=SUMPRODUCT(SIGN((njdata[StoreType]={"SIS","SIS M","SIS L","SIS P"})*((njdata[Season]="AW16")+(njdata[Season]="SS16")+(njdata[Season]="AW15")))*njdata[revenue])
The difference is that the first formula has two curly brackets defining the criteria to return the revenue, whereas the second formula has one. Can you not use two curly brackets criteria in excel formulas?
I can't find any information on the internet about using multiple criteria brackets in formulas.
=SUMPRODUCT(SIGN((njdata[StoreType]={"SIS","SIS M","SIS L","SIS P"})*(njdata[Season]={"AW16","SS16","AW15"}))*njdata[revenue])
When this one does:
=SUMPRODUCT(SIGN((njdata[StoreType]={"SIS","SIS M","SIS L","SIS P"})*((njdata[Season]="AW16")+(njdata[Season]="SS16")+(njdata[Season]="AW15")))*njdata[revenue])
The difference is that the first formula has two curly brackets defining the criteria to return the revenue, whereas the second formula has one. Can you not use two curly brackets criteria in excel formulas?
I can't find any information on the internet about using multiple criteria brackets in formulas.