Spreadsheet: 875548d1722151191-formula-scrambles-arguments-when-pulled-across-ron_ray-s3_dynamic_array_legacyformulas_issue_-aligw
Sheet: SUMIFS

SUMIFS & COUNTIFS with OR Condition (more than 1 criteria in one column)
 |  |  |  |  | 1. Create a summary table by Region and Division
Division | Region | App | Revenue
Game | Asia | Arcade | 4378 |  |  | Asia | North America | Europe
Game | Asia | Aviatrr | 5254 |  |  | Australia | South America
Game | Asia | Baden | 6130 |  | Division | Region 1 | Region 2 | Region 3
Game | Asia | deRamblr | 7443 |  |  |  | 22085 | 23168
Game | Asia | Fightrr | 13135 |  | Productivity | 6441 | 66798 | 37799
Game | Asia | Twistrr | 7443 |  | Utility | 7866 | 19336 | 0
Game | Australia | Arcade | 15890
Game | Australia | Aviatrr | 11917
Game | Australia | Baden | 1490
Game | Australia | Pes | 497
Game | Australia | Twistrr | 3476 |  |  |  | North America South America | Europe
Game | Europe | Arcade | 9267
Game | Europe | Aviatrr | 9731 |  |  |  | 22085 | 23168
Game | Europe | Kryptis | 927 |  |  |  | 66798 | 37799
Game | Europe | Perino | 463 |  |  |  | 19336 | #[NAME]!
Game | Europe | Pes | 463
Game | Europe | Twistrr | 2317 |  |  |  | 22085 | 23168
Game | North America | Arcade | 5361 |  |  | 6441 | 66798 | 37799
Game | North America | Aviatrr | 5808 |  |  | 7866 | 19336 | #[NAME]!
Game | North America | Pes | 4468
Game | North America | Twistrr | 1340
Game | South America | Arcade | 5108
Productivity | Asia | Halotot | 3513
Productivity | Asia | Inkly | 2928
Productivity | Europe | Blend | 911
Productivity | Europe | Dasring | 2277
Productivity | Europe | Didactic | 3188
Productivity | Europe | Flowrrr | 3643
Productivity | Europe | Halotot | 5465
Productivity | Europe | Right App | 5465
Productivity | Europe | Silvrr | 4554
Productivity | Europe | Sleops | 455
Productivity | Europe | Voltage | 911
Productivity | Europe | WenCaL | 10930
Productivity | North America | Blend | 1708
Productivity | North America | Dasring | 683
Productivity | North America | Didactic | 683
Productivity | North America | Flowrrr | 683
Productivity | North America | Halotot | 6148
Productivity | North America | Inkly | 1025
Productivity | North America | [NAME] | 683
Productivity | North America | Mirrrr | 1366
Productivity | North America | Pet Feed | 1708
Productivity | North America | Rehire | 6148
Productivity | North America | Right App | 7514
Productivity | North America | Silvrr | 683
Productivity | North America | Sleops | 342
Productivity | North America | Voltage | 3416
Productivity | North America | WenCaL | 1366
Productivity | South America | Blend | 1220
Productivity | South America | Dasring | 2732
Productivity | South America | Didactic | 9563
Productivity | South America | Sleops | 683
Productivity | South America | Voltage | 12979
Productivity | South America | WenCaL | 5465
Utility | Australia | Accord | 684
Utility | Australia | Amplefio | 4104
Utility | Australia | [NAME] | 0
Utility | Australia | Commuta | 1710
Utility | Australia | Infic | 684
Utility | Australia | Minor Liar | 684
Utility | North America | Minor Liar | 9723
Utility | South America | [NAME] | 2508
Utility | South America | Mosquit | 0
Utility | South America | Motocyco | 0
Utility | South America | Twenty20 | 7105