Spreadsheet: 805122d1668534064-if-function-with-several-conditions-if-function-multiple-criterias
Sheet: Sales Overview_All Categories

Black Friday Sale | [NAME] | E-Commerce Black Friday Sale | E-Commerce Winter Sale | LA Store Black Friday Sale | E-Commerce Black Friday Sale | China Phase 1 | China Phase 2 | China Phase 3
 |  |  |  |  |  |  |  |  |  |  | 22PF | RMB FX | 7
 |  |  |  |  |  |  |  |  |  |  | 22FW | USD FX | 1
 |  |  |  |  |  |  |  |  |  |  | 23CR
 |  |  |  |  |  | 30 |  |  |  |  | 23SS
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0
 |  | 30 | 40 | 30 | 40 |  | MD
 |  | 0 | 0 | 0 | 0 | MD
 |  |  |  |  |  | MD
 |  | 0 | 0
 |  |  |  |  |  |  |  | MD
 |  | 0 | 0
 |  |  |  |  |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0
 |  | 0 | 0 |  |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  |  |  |  |  |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  |  | 30
 |  |  |  |  |  |  |  | MD
 |  | 30 | 30 |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  | 0 | 0 | 0 | 0 | MD
 |  | 0 | 0 | 0 | 0 | MD
 |  |  |  |  |  |  |  | MD
 |  |  | 30 |  | 30 | MD
 |  |  | 30 |  |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  | 0 | 0 | 0 | 0
 |  | 30 | 40 | 30 | 40
 |  | 20 | 30 |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  | 30 | 30 |  |  |  | MD
 |  | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  |  | 30 |  |  |  | MD
 |  | 30 | 30 |  |  | MD
 |  |  |  |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  | 30 | 40 | 30 | 40 | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  |  | 30 |  |  | MD
 |  |  | 30 |  |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  |  |  |  |  |  | MD
 |  | 30 | 30 | 30 | 30 | MD
 |  |  | 30 |  |  |  | MD
 |  | 30 | 40 | 30 | 40 | MD
 |  |  | 30 |  |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  |  | 30 |  |  |  | MD
 |  | 0 | 0 | 0 | 0 | MD
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0
 |  |  |  | 0 | 0 | MD
 |  | 0 | 0
 |  | 20 | 30 |  |  |  | MD
 |  | 30 | 40 | 30 | 40 | MD
 |  | 30 | 30 | 30 | 30 | MD
 |  | 0 | 0
 |  | 30 | 30 | 30 | 30 | MD
 |  |  |  |  |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  |  | 30 |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  | 20 | 30 | 20 | 30
 |  | 30 | 40 |  |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 30 | 40 |  |  |  | MD
 |  | 30 | 40 | 30 | 40 |  | MD
 |  |  | 30 |  | 30 | MD
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0
 |  | 20 | 30 |  |  |  | MD
 |  | 0
 |  |  |  |  |  |  | MD
 |  | 0 | 0
 |  |  |  |  |  |  | MD
 |  | 30 | 40
 |  | 30 | 30
 |  | 30 | 40 | 30 | 40
 |  | 30 | 30 | 30 | 30 | MD
 |  | 30 | 40 | 30 | 40 | MD
 |  |  | 30 |  |  | MD
 |  | 30 | 30 | 30 | 30
 |  | 30 | 40 |  |  | MD
 |  | 30 | 40
 |  | 0 | 0
 |  | 0 | 0
 |  |  | 30 |  |  |  | MD
 |  |  |  | 30 | 40
 |  |  | 30 |  |  |  | MD
 |  | 30 | 40 |  |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  | 30 | 40
 |  |  | 30 |  | 30 | MD
 |  | 20 | 30 |  |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  | 30 | 30 | 30 | 30 | MD
 |  | 30 | 40 |  |  |  | MD
 |  |  | 30 |  |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  | 30 | 40 | 30 | 40 | MD
 |  | 30 | 40 |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  |  | 30 |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  | 30 | 40 |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | MD
 |  |  | 30 |  |  | MD
 |  | 0 | 0
 |  |  |  |  |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  | 0 | 0
 |  | 0 | 0
 |  | 30 | 40 | 30 | 40 | MD
 |  | 30 | 40 |  |  | MD
 |  | 0 | 0 |  |  | MD
 |  |  | 30 |  |  | MD
 |  |  |  |  |  |  | MD
 |  | 30 | 30 |  |  | MD
 |  | 30 | 30 |  |  | MD
 |  | 30 | 40 | 30 | 40 | MD
 |  | 30 | 40 |  |  | MD
 |  |  | 30 |  |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  |  |  |  |  |  | MD
 |  | 0 | 0
 |  | 0 | 0 |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  |  |  |  |  |  | MD
 |  | 20 | 30 |  |  |  | MD
 |  | 30 | 30 |  |  | MD
 |  |  | 30 |  | 30 |  | MD
 |  | 0 | 0 | 0 | 0 | MD
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  | 30 | 40 |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  | 30 | 40
 |  | 0
 |  | 30 | 40 | 30 | 40
 |  | 30 | 40
 |  | 30 | 40
 |  | 30 | 40 | 30 | 40
 |  |  |  | 0 | 0
 |  |  |  | 30 | 40 | MD
 |  |  |  |  |  |  | MD
 |  |  |  | 0 | 0
 |  |  |  |  |  |  | MD
 |  |  |  | 20 | 30 |  | MD
 |  |  |  | 30 | 30 | MD
 |  |  |  | 30 | 40 |  | MD
 |  |  |  | 30 | 40 | MD
 |  |  |  |  | 30 |  | MD
 |  |  |  | 0 | 0
 |  |  |  | 30 | 40 | MD
 |  |  |  | 0 | 0 | MD
 |  |  |  |  | 30 |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  | 0 | 0
 |  |  |  |  | 30 | MD
 |  |  |  | 0 | 0
 |  |  |  |  | 30
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD
 |  |  |  |  |  | MD