Spreadsheet: 266425d1379609241-i-need-countifs-or-sumproduct-formula-to-count-only-non-consecutive-values-countifs-example
Sheet: Sheet1

Position Size |  |  |  |  | Position
 |  |  |  |  | 1422376
Position [NAME] | Count Jobs w/ CountIf | Count Jobs w/ SumProduct | % of Total Jobs (Total = 186) |  | 1422376
1-2,500
2,501-5,000 |  |  |  |  | 123046
5,001-10,000 |  |  |  |  | 123046
10,001-25,000 |  |  |  |  | 123046
25,001-50,000
50,001-75,000 |  |  |  |  | 157145
75,001-125,000
125,001-250,000 |  |  |  |  | 90954
250,001-500,000
500,001-750,000 |  |  |  |  | 230998
750,001-1,000,000 |  |  |  |  | 230998
1,000,001-1,500,000
1,500,001-3,000,000 |  |  |  |  | 258894
3,000,001-5,000,000
TOTAL: |  |  |  |  | 152111
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 796177
 |  |  |  |  | 289938
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 121676
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 101057
 |  |  |  |  | 292845
 |  |  |  |  | 197923
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 31895
 |  |  |  |  | 145954
 |  |  |  |  | 49921
 |  |  |  |  | 549383
 |  |  |  |  | 36618
 |  |  |  |  | 65501
 |  |  |  |  | 65501
 |  |  |  |  | 108295
 |  |  |  |  | 158757
 |  |  |  |  | 514073
 |  |  |  |  | 514073
 |  |  |  |  | 514073
 |  |  |  |  | 528935
 |  |  |  |  | 528935
 |  |  |  |  | 528935
 |  |  |  |  | 10206
 |  |  |  |  | 10206
 |  |  |  |  | 326399
 |  |  |  |  | 1390356
 |  |  |  |  | 1390356
 |  |  |  |  | 138725
 |  |  |  |  | 432652
 |  |  |  |  | 21930
 |  |  |  |  | 4231566
 |  |  |  |  | 79084
 |  |  |  |  | 1626499
 |  |  |  |  | 255106
 |  |  |  |  | 132016
 |  |  |  |  | 21930
 |  |  |  |  | 21930
 |  |  |  |  | 21930
 |  |  |  |  | 816418
 |  |  |  |  | 816418
 |  |  |  |  | 816418
 |  |  |  |  | 146789
 |  |  |  |  | 173433
 |  |  |  |  | 21565
 |  |  |  |  | 59019
 |  |  |  |  | 2599125
 |  |  |  |  | 258029
 |  |  |  |  | 258029
 |  |  |  |  | 1040913
 |  |  |  |  | 1040913
 |  |  |  |  | 41391
 |  |  |  |  | 28467
 |  |  |  |  | 225931
 |  |  |  |  | 3267063
 |  |  |  |  | 3267063
 |  |  |  |  | 3267063
 |  |  |  |  | 3267063
 |  |  |  |  | 66530
 |  |  |  |  | 119312
 |  |  |  |  | 184046
 |  |  |  |  | 184046
 |  |  |  |  | 192806
 |  |  |  |  | 93445
 |  |  |  |  | 51625
 |  |  |  |  | 262136
 |  |  |  |  | 487233
 |  |  |  |  | 487233
 |  |  |  |  | 1495965
 |  |  |  |  | 1495965
 |  |  |  |  | 140051
 |  |  |  |  | 230758
 |  |  |  |  | 230758
 |  |  |  |  | 65787
 |  |  |  |  | 109413
 |  |  |  |  | 51210
 |  |  |  |  | 2105135
 |  |  |  |  | 2105135
 |  |  |  |  | 296393
 |  |  |  |  | 974075
 |  |  |  |  | 22285
 |  |  |  |  | 549009
 |  |  |  |  | 121581
 |  |  |  |  | 345142
 |  |  |  |  | 544178
 |  |  |  |  | 544179
 |  |  |  |  | 544180
 |  |  |  |  | 544181
 |  |  |  |  | 544182
 |  |  |  |  | 544183
 |  |  |  |  | 544184
 |  |  |  |  | 544185
 |  |  |  |  | 544186
 |  |  |  |  | 544187
 |  |  |  |  | 544188
 |  |  |  |  | 544189
 |  |  |  |  | 544190
 |  |  |  |  | 95241
 |  |  |  |  | 51113
 |  |  |  |  | 51113
 |  |  |  |  | 1211216
 |  |  |  |  | 394342
 |  |  |  |  | 72757
 |  |  |  |  | 78372
 |  |  |  |  | 78372
 |  |  |  |  | 70889
 |  |  |  |  | 279934
 |  |  |  |  | 279934
 |  |  |  |  | 13090
 |  |  |  |  | 61730
 |  |  |  |  | 2491783
 |  |  |  |  | 2491783
 |  |  |  |  | 2491783
 |  |  |  |  | 2491783
 |  |  |  |  | 2491783
 |  |  |  |  | 41951
 |  |  |  |  | 41951
 |  |  |  |  | 66225
 |  |  |  |  | 66225
 |  |  |  |  | 201113
 |  |  |  |  | 500928
 |  |  |  |  | 103275
 |  |  |  |  | 103275
 |  |  |  |  | 628064
 |  |  |  |  | 628064
 |  |  |  |  | 628064
 |  |  |  |  | 231317
 |  |  |  |  | 185084
 |  |  |  |  | 364088
 |  |  |  |  | 364088
 |  |  |  |  | 364088
 |  |  |  |  | 73895
 |  |  |  |  | 31707
 |  |  |  |  | 31707
 |  |  |  |  | 878058
 |  |  |  |  | 878058
 |  |  |  |  | 271463
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 106603
 |  |  |  |  | 1292510
 |  |  |  |  | 1292510
 |  |  |  |  | 1292510
 |  |  |  |  | 166813
 |  |  |  |  | 166813
 |  |  |  |  | 109889
 |  |  |  |  | 122303
 |  |  |  |  | 12567
 |  |  |  |  | 88092
 |  |  |  |  | 1561
 |  |  |  |  | 1561
 |  |  |  |  | 1561
 |  |  |  |  | 1561
 |  |  |  |  | 628216
 |  |  |  |  | 68271
 |  |  |  |  | 1118455
 |  |  |  |  | 1118455
 |  |  |  |  | 30338
 |  |  |  |  | 486730
 |  |  |  |  | 73012
 |  |  |  |  | 73012
 |  |  |  |  | 73012
 |  |  |  |  | 160184
 |  |  |  |  | 441801
 |  |  |  |  | 56001
 |  |  |  |  | 51463
 |  |  |  |  | 51463
 |  |  |  |  | 51463
 |  |  |  |  | 148409
 |  |  |  |  | 148409
 |  |  |  |  | 148409
 |  |  |  |  | 148409
 |  |  |  |  | 148409
 |  |  |  |  | 362411
 |  |  |  |  | 237583
 |  |  |  |  | 237583
 |  |  |  |  | 451402
 |  |  |  |  | 126182
 |  |  |  |  | 126182
 |  |  |  |  | 126182
 |  |  |  |  | 126182
 |  |  |  |  | 1349082
 |  |  |  |  | 172300
 |  |  |  |  | 192333
 |  |  |  |  | 50600
 |  |  |  |  | 50600
 |  |  |  |  | 33283
 |  |  |  |  | 549161
 |  |  |  |  | 549161
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 270911
 |  |  |  |  | 148421
 |  |  |  |  | 148421
 |  |  |  |  | 148421
 |  |  |  |  | 136893
 |  |  |  |  | 136893
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 84184
 |  |  |  |  | 115646
 |  |  |  |  | 239930
 |  |  |  |  | 239930
 |  |  |  |  | 239930
 |  |  |  |  | 239930
 |  |  |  |  | 239930
 |  |  |  |  | 239930
 |  |  |  |  | 59068
 |  |  |  |  | 59068
 |  |  |  |  | 930601
 |  |  |  |  | 54613
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 1584003
 |  |  |  |  | 8876
 |  |  |  |  | 8876
 |  |  |  |  | 8876
 |  |  |  |  | 209282
 |  |  |  |  | 64143
 |  |  |  |  | 64143
 |  |  |  |  | 79167
 |  |  |  |  | 79167
 |  |  |  |  | 75359
 |  |  |  |  | 968588
 |  |  |  |  | 70359
 |  |  |  |  | 122150
 |  |  |  |  | 65575
 |  |  |  |  | 65575
 |  |  |  |  | 1592
 |  |  |  |  | 804956
 |  |  |  |  | 23281
 |  |  |  |  | 3384
 |  |  |  |  | 3384
 |  |  |  |  | 3384
 |  |  |  |  | 3384
 |  |  |  |  | 701292
 |  |  |  |  | 86511
 |  |  |  |  | 1107574
 |  |  |  |  | 1595518
 |  |  |  |  | 43101
 |  |  |  |  | 43101
 |  |  |  |  | 43101
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 484399
 |  |  |  |  | 14340
 |  |  |  |  | 71771
 |  |  |  |  | 647809
 |  |  |  |  | 53274
 |  |  |  |  | 95758
 |  |  |  |  | 647719
 |  |  |  |  | 57793
 |  |  |  |  | 57793
 |  |  |  |  | 57793
 |  |  |  |  | 57793
 |  |  |  |  | 126348
 |  |  |  |  | 43102
 |  |  |  |  | 43102
 |  |  |  |  | 134786
 |  |  |  |  | 76762
 |  |  |  |  | 30851
 |  |  |  |  | 30851
 |  |  |  |  | 30851
 |  |  |  |  | 37167
 |  |  |  |  | 37167
 |  |  |  |  | 37167
 |  |  |  |  | 28500
 |  |  |  |  | 8958
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 2390415
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1845676
 |  |  |  |  | 1456
 |  |  |  |  | 1456
 |  |  |  |  | 1456
 |  |  |  |  | 1456
 |  |  |  |  | 1456
 |  |  |  |  | 1456
 |  |  |  |  | 77429
 |  |  |  |  | 77429
 |  |  |  |  | 56679
 |  |  |  |  | 19712
 |  |  |  |  | 296975
 |  |  |  |  | 296975
 |  |  |  |  | 296975
 |  |  |  |  | 296975
 |  |  |  |  | 296975
 |  |  |  |  | 296975
 |  |  |  |  | 45032
 |  |  |  |  | 45032
 |  |  |  |  | 45032
 |  |  |  |  | 45032
 |  |  |  |  | 45032
 |  |  |  |  | 43418
 |  |  |  |  | 28460
 |  |  |  |  | 28460
 |  |  |  |  | 28460
 |  |  |  |  | 28460
 |  |  |  |  | 28460
 |  |  |  |  | 28460
 |  |  |  |  | 28460
 |  |  |  |  | 499426
 |  |  |  |  | 499426
 |  |  |  |  | 554581
 |  |  |  |  | 554581
 |  |  |  |  | 225882
 |  |  |  |  | 225882
 |  |  |  |  | 225882
 |  |  |  |  | 225882
 |  |  |  |  | 20915
 |  |  |  |  | 20915
 |  |  |  |  | 339039
 |  |  |  |  | 339039
 |  |  |  |  | 339039
 |  |  |  |  | 339039
 |  |  |  |  | 67389
 |  |  |  |  | 67389
 |  |  |  |  | 67389
 |  |  |  |  | 1218092
 |  |  |  |  | 1218092
 |  |  |  |  | 1218092
 |  |  |  |  | 1218092
 |  |  |  |  | 423522
 |  |  |  |  | 423522
 |  |  |  |  | 423522
 |  |  |  |  | 44622
 |  |  |  |  | 44622
 |  |  |  |  | 44622
 |  |  |  |  | 44622
 |  |  |  |  | 158471
 |  |  |  |  | 158471
 |  |  |  |  | 158471