Spreadsheet: 801883d1666453508-how-to-extend-sumproduct-formula-beyond-the-current-range-gerti-example
Sheet: Sheet1

Account | Amount |  |  | Sum of "start with 1 or 2"
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000 |  |  | Sum of "start with 1 or 2" |  | *trying to extend the rage
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
1220130 | -35000
1413160 | -55000
1413430 | -25000
1413430 | -22000
1417011 | -14000
1417011 | -15000
1419011 | 600
1702005 | 100000
2000065 | 350000
2000065 | 14500
2016010 | -1668.26
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5
2016010 | -70.98
2016010 | -190.5
2016010 | -251.44
2016110 | 0.02
2016120 | -0.01
2031300 | 755
2120000 | 45000
2120000 | 150000
2443000 | -11699.49
2443000 | 54668
2900000 | 150000
5000000 | 138874.83
5000000 | 66135.22
5000000 | 155051.01
5000000 | 60072.68
5000000 | 7048.97
5000000 | 22804.56
5000000 | 67932.42
5000000 | 101226.67
5000000 | 67023.77
5000000 | 109025.47
5000000 | 744.72
5000000 | 106141.2
5000000 | 49582.74
5000000 | 42562.11
5000100 | 1966.49
5000100 | 1782.25
5000100 | 553.21
5000100 | 1023.97
5000100 | 166.36
5000100 | 4457.44
5000100 | 986.08
5000100 | 1643.94
5000100 | 1606.94
5000100 | 1341.85
5000100 | 461.98
5000100 | 201.09
5000100 | 287.76
5000100 | 367.73
5000100 | 1234.07
5000100 | 156.15
5000100 | 1245.99
5000100 | 2477.35
5003000 | -1169
5003000 | 4523
5003000 | 64499
2016010 | -190.5