Spreadsheet: 330235d1404645472-shortest-formula-challenge-games-1-3-excel-challenge-game-1-
Sheet: No Seven Sum

 | Explanation: |  |  |  |  | 452145 | 413396
 | The array G2:H291 contains random numbers between 1 and 1,000,000. |  |  |  |  | 10640 | 115650
 |  |  |  |  |  | 173390 | 99150
 |  |  |  |  |  | 460354 | 576452
 | Objective: |  |  |  |  | 408331 | 317341
 | What is the sum of all numbers after all instances of a "7" have been removed? |  |  |  |  | 863327 | 137012
 |  |  |  |  |  | 605280 | 41698
 |  |  |  |  |  | 795283 | 727811
 | Requirements: |  |  |  |  | 127458 | 798690
 | Any numbers |  |  |  |  | 997556 | 233485
 |  |  |  |  |  | 743325 | 324335
 | Solution: |  |  |  |  | 426643 | 94773
 |  |  |  |  |  | 117222 | 650576
 | [NAME] Used: |  |  |  |  | 313817 | 958979
 |  |  |  |  |  | 194614 | 706036
 |  |  |  |  |  | 826857 | 29867
 |  |  |  |  |  | 686391 | 346042
 |  |  |  |  |  | 666238 | 134774
 | [NAME]: |  |  |  |  | 630177 | 151446
 |  |  |  |  |  | 376574 | 451885
 |  |  |  |  |  | 24952 | 876888
 |  |  |  |  |  | 576313 | 676767
 |  |  |  |  |  | 786948 | 101026
 |  |  |  |  |  | 256971 | 986217
 |  |  |  |  |  | 569526 | 820521
 |  |  |  |  |  | 301936 | 918620
 |  |  |  |  |  | 549069 | 552940
 |  |  |  |  |  | 434923 | 929074
 |  |  |  |  |  | 849592 | 478759
 |  |  |  |  |  | 955507 | 869052
 |  |  |  |  |  | 650205 | 902110
 |  |  |  |  |  | 628950 | 667608
 |  |  |  |  |  | 970558 | 485700
 |  |  |  |  |  | 698603 | 52687
 |  |  |  |  |  | 885159 | 143967
 |  |  |  |  |  | 852823 | 650267
 |  |  |  |  |  | 486503 | 149779
 |  |  |  |  |  | 320905 | 693030
 |  |  |  |  |  | 109808 | 561250
 |  |  |  |  |  | 833222 | 518040
 |  |  |  |  |  | 862184 | 609803
 |  |  |  |  |  | 77926 | 517447
 |  |  |  |  |  | 324691 | 308462
 |  |  |  |  |  | 446239 | 722692
 |  |  |  |  |  | 553029 | 980864
 |  |  |  |  |  | 53807 | 650266
 |  |  |  |  |  | 560688 | 465580
 |  |  |  |  |  | 127769 | 263678
 |  |  |  |  |  | 532791 | 685213
 |  |  |  |  |  | 434434 | 167981
 |  |  |  |  |  | 706245 | 958767
 |  |  |  |  |  | 383676 | 204117
 |  |  |  |  |  | 72547 | 876950
 |  |  |  |  |  | 66721 | 626355
 |  |  |  |  |  | 880234 | 252520
 |  |  |  |  |  | 177583 | 558748
 |  |  |  |  |  | 592192 | 465050
 |  |  |  |  |  | 658817 | 836310
 |  |  |  |  |  | 27180 | 314108
 |  |  |  |  |  | 948922 | 455434
 |  |  |  |  |  | 285963 | 176586
 |  |  |  |  |  | 415781 | 894500
 |  |  |  |  |  | 215034 | 213879
 |  |  |  |  |  | 79672 | 106268
 |  |  |  |  |  | 966401 | 445639
 |  |  |  |  |  | 720406 | 130498
 |  |  |  |  |  | 868914 | 910115
 |  |  |  |  |  | 301009 | 214773
 |  |  |  |  |  | 331328 | 304975
 |  |  |  |  |  | 753948 | 565574
 |  |  |  |  |  | 449741 | 895923
 |  |  |  |  |  | 277451 | 982262
 |  |  |  |  |  | 216213 | 271674
 |  |  |  |  |  | 508304 | 881263
 |  |  |  |  |  | 175485 | 965225
 |  |  |  |  |  | 485957 | 623674
 |  |  |  |  |  | 696921 | 999212
 |  |  |  |  |  | 362582 | 269701
 |  |  |  |  |  | 809554 | 419233
 |  |  |  |  |  | 54573 | 332678
 |  |  |  |  |  | 263717 | 707638
 |  |  |  |  |  | 635763 | 532555
 |  |  |  |  |  | 853397 | 641342
 |  |  |  |  |  | 86700 | 917337
 |  |  |  |  |  | 836469 | 83819
 |  |  |  |  |  | 976076 | 796639
 |  |  |  |  |  | 692836 | 211870
 |  |  |  |  |  | 926271 | 237033
 |  |  |  |  |  | 710964 | 178771
 |  |  |  |  |  | 9660 | 971562
 |  |  |  |  |  | 273183 | 208163
 |  |  |  |  |  | 987927 | 331486
 |  |  |  |  |  | 838030 | 74433
 |  |  |  |  |  | 632299 | 799831
 |  |  |  |  |  | 148109 | 630391
 |  |  |  |  |  | 170255 | 51518
 |  |  |  |  |  | 813683 | 375647
 |  |  |  |  |  | 520398 | 930102
 |  |  |  |  |  | 175779 | 106877
 |  |  |  |  |  | 118308 | 39976
 |  |  |  |  |  | 620316 | 407242
 |  |  |  |  |  | 563909 | 432328
 |  |  |  |  |  | 237813 | 425236
 |  |  |  |  |  | 971578 | 223159
 |  |  |  |  |  | 249192 | 411521
 |  |  |  |  |  | 296597 | 52025
 |  |  |  |  |  | 408347 | 632889
 |  |  |  |  |  | 4457 | 259965
 |  |  |  |  |  | 945823 | 221937
 |  |  |  |  |  | 442551 | 541873
 |  |  |  |  |  | 534197 | 406854
 |  |  |  |  |  | 309252 | 620975
 |  |  |  |  |  | 743689 | 371878
 |  |  |  |  |  | 121243 | 423242
 |  |  |  |  |  | 909259 | 158753
 |  |  |  |  |  | 905286 | 580211
 |  |  |  |  |  | 903820 | 527840
 |  |  |  |  |  | 620422 | 341812
 |  |  |  |  |  | 180700 | 760455
 |  |  |  |  |  | 110048 | 792966
 |  |  |  |  |  | 410255 | 866768
 |  |  |  |  |  | 42491 | 338508
 |  |  |  |  |  | 362603 | 851092
 |  |  |  |  |  | 550089 | 586730
 |  |  |  |  |  | 81839 | 854961
 |  |  |  |  |  | 565506 | 340332
 |  |  |  |  |  | 505820 | 105218
 |  |  |  |  |  | 157550 | 681609
 |  |  |  |  |  | 610284 | 656249
 |  |  |  |  |  | 447928 | 658747
 |  |  |  |  |  | 148996 | 29281
 |  |  |  |  |  | 564306 | 441588
 |  |  |  |  |  | 312595 | 979353
 |  |  |  |  |  | 379370 | 745815
 |  |  |  |  |  | 87119 | 474346
 |  |  |  |  |  | 123507 | 611324
 |  |  |  |  |  | 337760 | 915755
 |  |  |  |  |  | 144674 | 375665
 |  |  |  |  |  | 826258 | 520148
 |  |  |  |  |  | 910217 | 606726
 |  |  |  |  |  | 211366 | 474221
 |  |  |  |  |  | 360284 | 941204
 |  |  |  |  |  | 722869 | 14778
 |  |  |  |  |  | 939478 | 512236
 |  |  |  |  |  | 449897 | 492657
 |  |  |  |  |  | 98404 | 671353
 |  |  |  |  |  | 214690 | 870558
 |  |  |  |  |  | 586167 | 805923
 |  |  |  |  |  | 75337 | 609509
 |  |  |  |  |  | 875099 | 268409
 |  |  |  |  |  | 322415 | 123694
 |  |  |  |  |  | 414221 | 883051
 |  |  |  |  |  | 619134 | 509950
 |  |  |  |  |  | 430759 | 31876
 |  |  |  |  |  | 331118 | 430108
 |  |  |  |  |  | 197321 | 68033
 |  |  |  |  |  | 547841 | 572200
 |  |  |  |  |  | 364704 | 169039
 |  |  |  |  |  | 466336 | 284961
 |  |  |  |  |  | 326444 | 15079
 |  |  |  |  |  | 470645 | 346618
 |  |  |  |  |  | 26534 | 517788
 |  |  |  |  |  | 178648 | 87803
 |  |  |  |  |  | 3640 | 798
 |  |  |  |  |  | 687913 | 970584
 |  |  |  |  |  | 936699 | 684689
 |  |  |  |  |  | 755871 | 108255
 |  |  |  |  |  | 990539 | 354192
 |  |  |  |  |  | 963122 | 66409
 |  |  |  |  |  | 454521 | 4982
 |  |  |  |  |  | 569752 | 781978
 |  |  |  |  |  | 657796 | 392566
 |  |  |  |  |  | 790198 | 631611
 |  |  |  |  |  | 203142 | 925698
 |  |  |  |  |  | 697668 | 98066
 |  |  |  |  |  | 262053 | 326409
 |  |  |  |  |  | 211230 | 100005
 |  |  |  |  |  | 805233 | 967720
 |  |  |  |  |  | 916965 | 612354
 |  |  |  |  |  | 271997 | 297997
 |  |  |  |  |  | 719413 | 421271
 |  |  |  |  |  | 531001 | 871392
 |  |  |  |  |  | 655779 | 541588
 |  |  |  |  |  | 63515 | 806951
 |  |  |  |  |  | 855059 | 703523
 |  |  |  |  |  | 76867 | 287771
 |  |  |  |  |  | 73116 | 307013
 |  |  |  |  |  | 612858 | 941835
 |  |  |  |  |  | 501129 | 939079
 |  |  |  |  |  | 3669 | 396439
 |  |  |  |  |  | 644728 | 439836
 |  |  |  |  |  | 277709 | 981968
 |  |  |  |  |  | 983456 | 386720
 |  |  |  |  |  | 331807 | 412520
 |  |  |  |  |  | 171757 | 829879
 |  |  |  |  |  | 578226 | 377658
 |  |  |  |  |  | 673639 | 258513
 |  |  |  |  |  | 532047 | 706595
 |  |  |  |  |  | 780168 | 916679
 |  |  |  |  |  | 904115 | 636610
 |  |  |  |  |  | 911890 | 692519
 |  |  |  |  |  | 269629 | 371343
 |  |  |  |  |  | 816508 | 835376
 |  |  |  |  |  | 220651 | 580796
 |  |  |  |  |  | 666978 | 820091
 |  |  |  |  |  | 857075 | 52212
 |  |  |  |  |  | 425135 | 587351
 |  |  |  |  |  | 260037 | 374377
 |  |  |  |  |  | 854511 | 306653
 |  |  |  |  |  | 112765 | 182079
 |  |  |  |  |  | 171699 | 368605
 |  |  |  |  |  | 325803 | 51823
 |  |  |  |  |  | 334491 | 176095
 |  |  |  |  |  | 44395 | 700582
 |  |  |  |  |  | 641686 | 495545
 |  |  |  |  |  | 52834 | 564592
 |  |  |  |  |  | 901182 | 321025
 |  |  |  |  |  | 205288 | 91175
 |  |  |  |  |  | 103095 | 486109
 |  |  |  |  |  | 728423 | 573654
 |  |  |  |  |  | 860274 | 337323
 |  |  |  |  |  | 294771 | 901526
 |  |  |  |  |  | 376029 | 701493
 |  |  |  |  |  | 663680 | 982199
 |  |  |  |  |  | 60290 | 473666
 |  |  |  |  |  | 22208 | 758680
 |  |  |  |  |  | 429695 | 925748
 |  |  |  |  |  | 105419 | 494659
 |  |  |  |  |  | 475383 | 387728
 |  |  |  |  |  | 143820 | 764914
 |  |  |  |  |  | 741167 | 51948
 |  |  |  |  |  | 213477 | 828637
 |  |  |  |  |  | 876835 | 55544
 |  |  |  |  |  | 356262 | 685248
 |  |  |  |  |  | 208878 | 668309
 |  |  |  |  |  | 989745 | 928510
 |  |  |  |  |  | 520733 | 271892
 |  |  |  |  |  | 198434 | 756110
 |  |  |  |  |  | 868695 | 499661
 |  |  |  |  |  | 597803 | 461245
 |  |  |  |  |  | 486885 | 69959
 |  |  |  |  |  | 713595 | 511388
 |  |  |  |  |  | 155956 | 798356
 |  |  |  |  |  | 849604 | 739557
 |  |  |  |  |  | 978855 | 669608
 |  |  |  |  |  | 456022 | 631253
 |  |  |  |  |  | 464943 | 540519
 |  |  |  |  |  | 43124 | 278523
 |  |  |  |  |  | 733698 | 498339
 |  |  |  |  |  | 852172 | 625435
 |  |  |  |  |  | 338238 | 239384
 |  |  |  |  |  | 383248 | 10618
 |  |  |  |  |  | 332470 | 431439
 |  |  |  |  |  | 613730 | 967451
 |  |  |  |  |  | 685263 | 144812
 |  |  |  |  |  | 137678 | 977589
 |  |  |  |  |  | 925505 | 955572
 |  |  |  |  |  | 336949 | 833241
 |  |  |  |  |  | 678182 | 342990
 |  |  |  |  |  | 671445 | 781452
 |  |  |  |  |  | 457489 | 492137
 |  |  |  |  |  | 510092 | 326592
 |  |  |  |  |  | 815847 | 798372
 |  |  |  |  |  | 646759 | 115695
 |  |  |  |  |  | 987466 | 441468
 |  |  |  |  |  | 269181 | 925229
 |  |  |  |  |  | 228815 | 112198
 |  |  |  |  |  | 990054 | 643305
 |  |  |  |  |  | 828037 | 470214
 |  |  |  |  |  | 810187 | 543553
 |  |  |  |  |  | 206186 | 2510
 |  |  |  |  |  | 361082 | 727449
 |  |  |  |  |  | 959292 | 47011
 |  |  |  |  |  | 480582 | 794792
 |  |  |  |  |  | 476009 | 253911
 |  |  |  |  |  | 841602 | 966773
 |  |  |  |  |  | 272418 | 141772
 |  |  |  |  |  | 590464 | 400280
 |  |  |  |  |  | 26324 | 781758
 |  |  |  |  |  | 17118 | 454519
 |  |  |  |  |  | 444518 | 617014
 |  |  |  |  |  | 470474 | 967498
 |  |  |  |  |  | 398120 | 687949
 |  |  |  |  |  | 617186 | 646895
 |  |  |  |  |  | 56199 | 584339
 |  |  |  |  |  | 944979 | 234748
 |  |  |  |  |  | 447289 | 853517
 |  |  |  |  |  | 59407 | 183080
 |  |  |  |  |  | 671050 | 908077
 |  |  |  |  |  | 617478 | 904322