Spreadsheet: 112988d1308937128-lookup-or-index-issue-sample_countif_sumif
Sheet: NAR Performance

 |  | Country | Tenure (M) | Bucket Range | Performance (SWAT) |  | YTD NAR | YTD NAR / week | YTD NAR % to Plan |  |  | Bucket |  | [NAME]
 |  | CA | 4.582422618046833 |  |  |  | 2418.4 | 121.7907310742457 | 0.6089536553712284 |  |  | 0-3 |  |  | < 50%
 |  | US | 14.04397147689173 |  |  |  | 657 | 31.28571428571428 | 0.1564285714285714 |  |  | 4-6 |  | 0.5 | 0.7499
 |  | US | 17.73628322668486 |  |  |  | 4517 | 215.0952380952381 | 1.07547619047619 |  |  | 7-9 |  | 0.75 | 0.8499
 |  | US | 24.16486171962826 |  |  |  | 3692 | 175.8095238095238 | 0.8790476190476191 |  |  | 10-12 |  | 0.85 | 0.9499
 |  | US | 2.505497258788196 |  |  |  | 1650 | 151.9746862425258 | 0.7598734312126288 |  |  | 13-24 |  | 0.95 | 0.9999
 |  | CA | 5.505500555495115 |  |  |  | 921 | 43.85714285714285 | 0.2192857142857143 |  |  | 25 |  |  | 1
 |  | US | 33.42860816330568 |  |  |  | 2122 | 101.0476190476191 | 0.5052380952380953 |  |  |  |  |  | >100%
 |  | CA | 13.45056423138927 |  |  |  | 2465 | 117.3809523809524 | 0.5869047619047619
 |  | US | 2.736266743150267 |  |  |  | 983 | 82.90416107927429 | 0.4145208053963715
 |  | US | 63.39567406118029 |  |  |  | 3828 | 182.2857142857143 | 0.9114285714285715
 |  | US | 4.351653133684762 |  |  |  | 0 | 0 | 0
 |  | US | 8.703306267369523 |  |  |  | 3628.25 | 172.7738095238095 | 0.8638690476190476
 |  | CA | 133.9122350683902 |  |  |  | 8612 | 410.0952380952381 | 2.050476190476191
 |  | US | 23.50552033573663 |  |  |  | 7203 | 343 | 1.715
 |  | US | 17.96705271104694 |  |  |  | 4269.75 | 203.3214285714286 | 1.016607142857143
 |  | US | 16.91210649682032 |  |  |  | 3797.5 | 180.8333333333333 | 0.9041666666666667
 |  | US | 9.659351274012389 |  |  |  | 1760 | 83.80952380952381 | 0.4190476190476191
 |  | US | 5.736270039857186 |  |  |  | 4070 | 193.8095238095238 | 0.969047619047619
 |  | US | 4.813192102408903 |  |  |  | 4323 | 207.2684898946009 | 1.036342449473004
 |  | CA | 34.978060415451 |  |  |  | 4928 | 234.6666666666667 | 1.173333333333333
 |  | US | 15.42858838306416 |  |  |  | 1987.35 | 94.63571428571429 | 0.4731785714285714
 |  | US | 29.73629641351254 |  |  |  | 27845.5 | 1325.97619047619 | 6.629880952380953
 |  | US | 50.50555000609891 |  |  |  | 721 | 34.33333333333334 | 0.1716666666666667
 |  | CA | 4.582422618046833 |  |  |  | 1682.5 | 84.73077449239925 | 0.4236538724619963
 |  | US | 20.50551703902971 |  |  |  | 3401.5 | 161.9761904761905 | 0.8098809523809524
 |  | US | 96.89021636287512 |  |  |  | 2701.25 | 128.6309523809524 | 0.643154761904762
 |  | US | 84.85723610685287 |  |  |  | 5363 | 255.3809523809524 | 1.276904761904762
 |  | US | 19.35166961721936 |  |  |  | 1984 | 94.47619047619048 | 0.4723809523809524
 |  | US | 8.505503852202034 |  |  |  | 2438 | 116.0952380952381 | 0.5804761904761905
 |  | US | 17.73628322668486 |  |  |  | 5839 | 278.047619047619 | 1.390238095238095
 |  | US | 3.428575196236479 |  |  |  | 1044 | 70.26969408640421 | 0.3513484704320211
 |  | CA | 3.857147095766039 |  |  |  | 1057 | 63.23973320504832 | 0.3161986660252416
 |  | US | 2.736266743150267 |  |  |  | 1084 | 91.42228953197693 | 0.4571114476598847
 |  | CA | 6.428578492943399 |  |  |  | 2234.76 | 106.4171428571429 | 0.5320857142857144
 |  | US | 47.27477722502991 |  |  |  | 3940 | 187.6190476190476 | 0.9380952380952381
 |  | US | 33.1978386789436 |  |  |  | 5211 | 248.1428571428571 | 1.240714285714286
 |  | US | 3.428575196236479 |  |  |  | 2238 | 150.6356085875217 | 0.7531780429376083
 |  | US | 18.42859167977108 |  |  |  | 1492 | 71.04761904761905 | 0.3552380952380952
 |  | US | 3.65934468059855 |  |  |  | 627 | 39.5408012494067 | 0.1977040062470335
 |  | US | 15.8901273517883 |  |  |  | 2101 | 100.0476190476191 | 0.5002380952380953
 |  | US | 5.736270039857186 |  |  |  | 4661.83 | 221.9919047619047 | 1.109959523809524
 |  | CA | 3.824180026571458 |  |  |  | 1489.25 | 89.86912702710445 | 0.4493456351355223
 |  | US | 101.1759353581707 |  |  |  | 1817.2 | 86.53333333333333 | 0.4326666666666666
 |  | CA | 15.8901273517883 |  |  |  | 5259 | 250.4285714285714 | 1.252142857142857
 |  | US | 98.96714172213376 |  |  |  | 6407.309999999999 | 305.11 | 1.52555
 |  | US | 63.03303630003989 |  |  |  | 4326 | 206 | 1.03
 |  | CA | 8.967042820926176 |  |  |  | 2237.5 | 106.5476190476191 | 0.5327380952380952
 |  | US | 47.17587601744617 |  |  |  | 3805 | 181.1904761904762 | 0.905952380952381
 |  | US | 16.35166632051244 |  |  |  | 5952.4 | 283.447619047619 | 1.417238095238095
 |  | US | 17.70331615749028 |  |  |  | 3764 | 179.2380952380952 | 0.8961904761904762
 |  | US | 11.27473766454688 |  |  |  | 1445.5 | 68.83333333333333 | 0.3441666666666667
 |  | US | 14.04397147689173 |  |  |  | 2495 | 118.8095238095238 | 0.594047619047619
 |  | US | 4.549455548852252 |  |  |  | 332 | 16.84069074778836 | 0.08420345373894178
 |  | US | 3.428575196236479 |  |  |  | 5426 | 365.2139464682272 | 1.826069732341136
 |  | US | 7.582425914753752 |  |  |  | 2402 | 114.3809523809524 | 0.5719047619047619
 |  | CA | 85.58251162913365 |  |  |  | 5896 | 280.7619047619048 | 1.403809523809524
 |  | US | 14.40660923803213 |  |  |  | 0 | 0 | 0
 |  | US | 53.50555330280582 |  |  |  | 3135 | 149.2857142857143 | 0.7464285714285714
 |  | US | 13.45056423138927 |  |  |  | 3971 | 189.0952380952381 | 0.9454761904761905
 |  | CA | 63.85721302990443 |  |  |  | 3242.5 | 154.4047619047619 | 0.7720238095238096
 |  | US | 12.42858508635724 |  |  |  | 3911.17 | 186.2461904761905 | 0.9312309523809524
 |  | US | 2.274727774426126 |  |  |  | 646 | 65.53666399440529 | 0.3276833199720265
 |  | US | 17.73628322668486 |  |  |  | 7746 | 368.8571428571428 | 1.844285714285714
 |  | US | 80.04404400444396 |  |  |  | 4702.5 | 223.9285714285714 | 1.119642857142857
 |  | CA | 67.12095288016799 |  |  |  | 7495 | 356.9047619047619 | 1.78452380952381
 |  | US | 4.747257964019741 |  |  |  | 2057.5 | 100.0180205713121 | 0.5000901028565604
 |  | US | 5.505500555495115 |  |  |  | 460 | 21.90476190476191 | 0.1095238095238095
 |  | US | 31.58245228840911 |  |  |  | 0 | 0 | 0
 |  | US | 7.912096606699567 |  |  |  | 1047.5 | 49.88095238095238 | 0.2494047619047619
 |  | US | 7.120886946029611 |  |  |  | 2652 | 126.2857142857143 | 0.6314285714285715
 |  | US | 17.27474425796072 |  |  |  | 3144.25 | 149.7261904761905 | 0.7486309523809523
 |  | CA | 48.16488809328361 |  |  |  | 4039.65 | 192.3642857142857 | 0.9618214285714286
 |  | US | 8.967042820926176 |  |  |  | 0 | 0 | 0
 |  | US | 4.780225033214322 |  |  |  | 2446.5 | 118.1076752845049 | 0.5905383764225242
 |  | US | 5.043961586770974 |  |  |  | 2363 | 112.5238095238095 | 0.5626190476190476
 |  | US | 5.736270039857186 |  |  |  | 796 | 37.90476190476191 | 0.1895238095238095
 |  | US | 14.90111527595085 |  |  |  | 2227 | 106.0476190476191 | 0.5302380952380953
 |  | US | 7.3186893611971 |  |  |  | 721 | 34.33333333333334 | 0.1716666666666667
 |  | US | 13.81320199252966 |  |  |  | 4017.5 | 191.3095238095238 | 0.9565476190476191
 |  | US | 20.04397807030557 |  |  |  | 3142 | 149.6190476190476 | 0.7480952380952381
 |  | US | 32.93410212538695 |  |  |  | 1788.5 | 85.16666666666667 | 0.4258333333333333
 |  | US | 32.50553022585739 |  |  |  | 2182 | 103.9047619047619 | 0.5195238095238095
 |  | US | 46.81323825630577 |  |  |  | 5176.5 | 246.5 | 1.2325
 |  | US | 11.27473766454688 |  |  |  | 4567.5 | 217.5 | 1.0875
 |  | CA | 99.19791120649583 |  |  |  | 4487 | 213.6666666666667 | 1.068333333333333
 |  | US | 24.19782878882284 |  |  |  | 4928 | 234.6666666666667 | 1.173333333333333
 |  | CA | 4.351653133684762 |  |  |  | 355 | 18.82588170258652 | 0.09412940851293262
 |  | CA | 44.47257634349049 |  |  |  | 778 | 37.04761904761905 | 0.1852380952380952
 |  | US | 8.967042820926176 |  |  |  | 5522 | 262.952380952381 | 1.314761904761905
 |  | US | 64.58248855218523 |  |  |  | 2957.85 | 140.85 | 0.70425
 |  | US | 61.78028767064579 |  |  |  | 4544 | 216.3809523809524 | 1.081904761904762
 |  | CA | 4.978027448381811 |  |  |  | 6254 | 297.8095238095238 | 1.489047619047619
 |  | CA | 20.63738531580804 |  |  |  | 10291.92 | 490.0914285714286 | 2.450457142857143
 |  | US | 4.582422618046833 |  |  |  | 542.5 | 27.32032401909456 | 0.1366016200954728
 |  | US | 10.81319869582274 |  |  |  | 2017.5 | 96.07142857142857 | 0.4803571428571429
 |  | US | 48.79126240798067 |  |  |  | 3793 | 180.6190476190476 | 0.9030952380952381
 |  | US | 2.967036227512338 |  |  |  | 11435.75 | 889.4530867545135 | 4.447265433772568
 |  | US | 5.043961586770974 |  |  |  | 1815.92 | 86.47238095238096 | 0.4323619047619048
 |  | CA | 8.703306267369523 |  |  |  | 1690.75 | 80.51190476190476 | 0.4025595238095238
 |  | US | 14.50551044561587 |  |  |  | 3116.5 | 148.4047619047619 | 0.7420238095238095
 |  | US | 75.42865431720254 |  |  |  | 2897.75 | 137.9880952380952 | 0.6899404761904762
 |  | US | 3.197805711874409 |  |  |  | 411.5 | 29.69607208715246 | 0.1484803604357623
 |  | CA | 52.81324484971961 |  |  |  | 7960.33 | 379.0633333333333 | 1.895316666666667
 |  | US | 4.351653133684762 |  |  |  | 3183 | 168.7965674910786 | 0.8439828374553932
 |  | US | 2.274727774426126 |  |  |  | 450 | 45.65247491870338 | 0.2282623745935169
 |  | US | 4.582422618046833 |  |  |  | 3100.89 | 156.1609576913735 | 0.7808047884568675
 |  | US | 16.91210649682032 |  |  |  | 2874.25 | 136.8690476190476 | 0.6843452380952381
 |  | US | 18.85716357930064 |  |  |  | 1566.41 | 74.59095238095237 | 0.3729547619047618
 |  | US | 11.04396818018481 |  |  |  | 4671 | 222.4285714285714 | 1.112142857142857
 |  | US | 90.1319671779859 |  |  |  | 1515 | 72.14285714285714 | 0.3607142857142857
 |  | US | 17.96705271104694 |  |  |  | 3707.5 | 176.547619047619 | 0.8827380952380952
 |  | US | 14.17583975367006 |  |  |  | 3216 | 153.1428571428571 | 0.7657142857142857
 |  | CA | 5.736270039857186 |  |  |  | 3906 | 186 | 0.93
 |  | US | 15.65935786742623 |  |  |  | 2887.25 | 137.4880952380952 | 0.6874404761904762
 |  | CA | 94.58252151925441 |  |  |  | 7518.26 | 358.012380952381 | 1.790061904761905
 |  | US | 18.19782219540901 |  |  |  | 3270.5 | 155.7380952380952 | 0.7786904761904762
 |  | US | 30.8901438353229 |  |  |  | 4339 | 206.6190476190476 | 1.033095238095238
 |  | US | 6.659347977305469 |  |  |  | 3373.85 | 160.6595238095238 | 0.803297619047619
 |  | US | 7.351656430391682 |  |  |  | 2005 | 95.47619047619048 | 0.4773809523809524
 |  | CA | 4.120883649322692 |  |  |  | 1866 | 104.4966889899153 | 0.5224834449495764
 |  | US | 3.428575196236479 |  |  |  | 1146.5 | 77.16877803645826 | 0.3858438901822913
 |  | CA | 14.83518113756169 |  |  |  | 3224 | 153.5238095238095 | 0.7676190476190476
 |  | US | 14.01100440769715 |  |  |  | 1398 | 66.57142857142857 | 0.3328571428571429
 |  | US | 5.505500555495115 |  |  |  | 2075 | 98.80952380952381 | 0.4940476190476191
 |  | US | 17.63738201910112 |  |  |  | 1981.85 | 94.37380952380951 | 0.4718690476190476
 |  | US | 4.813192102408903 |  |  |  | 1910.5 | 91.59991902466689 | 0.4579995951233345
 |  | CA | 2.637365535566523 |  |  |  | 992 | 86.8005723120947 | 0.4340028615604735
 |  | US | 11.50550714890895 |  |  |  | 3202 | 152.4761904761905 | 0.7623809523809524
 |  | US | 13.35166302380552 |  |  |  | 4536 | 216 | 1.08
 |  | US | 15.42858838306416 |  |  |  | 1614.5 | 76.88095238095238 | 0.3844047619047619
 |  | CA | 8.967042820926176 |  |  |  | 5144 | 244.952380952381 | 1.224761904761905
 |  | US | 12.89012405508138 |  |  |  | 1989 | 94.71428571428571 | 0.4735714285714286
 |  | US | 4.120883649322692 |  |  |  | 1332 | 74.59249181916783 | 0.3729624590958391
 |  | US | 9.89012075837446 |  |  |  | 2963 | 141.0952380952381 | 0.7054761904761905
 |  | US | 47.27477722502991 |  |  |  | 5030 | 239.5238095238095 | 1.197619047619048
 |  | US | 17.96705271104694 |  |  |  | 1358.25 | 64.67857142857143 | 0.3233928571428571
 |  | US | 56.47258953031816 |  |  |  | 915 | 43.57142857142857 | 0.2178571428571429
 |  | CA | 47.40664550180824 |  |  |  | 3124 | 148.7619047619048 | 0.7438095238095238
 |  | US | 7.351656430391682 |  |  |  | 1825.25 | 86.91666666666667 | 0.4345833333333333
 |  | US | 24.89013724190906 |  |  |  | 5154 | 245.4285714285714 | 1.227142857142857
 |  | US | 4.120883649322692 |  |  |  | 2264 | 126.7848359448919 | 0.6339241797244594
 |  | US | 11.90111197924393 |  |  |  | 4147 | 197.4761904761905 | 0.9873809523809524
 |  | US | 7.120886946029611 |  |  |  | 0 | 0 | 0
 |  | US | 54.89017020897825 |  |  |  | 2188 | 104.1904761904762 | 0.520952380952381
 |  | US | 3.428575196236479 |  |  |  | 1179 | 79.35629245964613 | 0.3967814622982306
 |  | CA | 6.89011746166754 |  |  |  | 2236.9 | 106.5190476190476 | 0.5325952380952381
 |  | US | 76.5825017390129 |  |  |  | 4453.5 | 212.0714285714286 | 1.060357142857143
 |  | CA | 57.85720643649059 |  |  |  | 6609 | 314.7142857142857 | 1.573571428571429
 |  | CA | 56.9341284990423 |  |  |  | 5712 | 272 | 1.36
 |  | US | 6.89011746166754 |  |  |  | 3228 | 153.7142857142857 | 0.7685714285714286
 |  | US | 47.17587601744617 |  |  |  | 1915 | 91.19047619047619 | 0.4559523809523809
 |  | US | 32.50553022585739 |  |  |  | 0 | 0 | 0
 |  | CA | 73.3517289579439 |  |  |  | 1980.5 | 94.30952380952381 | 0.471547619047619
 |  | CA | 17.73628322668486 |  |  |  | 3636.5 | 173.1666666666667 | 0.8658333333333333
 |  | US | 12.42858508635724 |  |  |  | 7288 | 347.047619047619 | 1.735238095238095
 |  | CA | 95.73636894106477 |  |  |  | 6359 | 302.8095238095238 | 1.514047619047619
 |  | US | 61.12094628675416 |  |  |  | 0 | 0 | 0
 |  | US | 24.16486171962826 |  |  |  | 841 | 40.04761904761905 | 0.2002380952380952
 |  | US | 66.42864442708178 |  |  |  | 2554.75 | 121.6547619047619 | 0.6082738095238095
 |  | US | 44.04400444396092 |  |  |  | 3386 | 161.2380952380952 | 0.8061904761904762
 |  | US | 14.20880682286464 |  |  |  | 2192 | 104.3809523809524 | 0.5219047619047619
 |  | US | 5.010994517576393 |  |  |  | 2998 | 142.7619047619048 | 0.7138095238095238
 |  | US | 2.241760705231544 |  |  |  | 510 | 52.5003461565089 | 0.2625017307825445
 |  | US | 18.19782219540901 |  |  |  | 4328 | 206.0952380952381 | 1.030476190476191
 |  | US | 7.120886946029611 |  |  |  | 0 | 0 | 0
 |  | US | 14.50551044561587 |  |  |  | 6031.5 | 287.2142857142857 | 1.436071428571429
 |  | US | 59.96709886494381 |  |  |  | 0 | 0 | 0
 |  | US | 11.80221077166019 |  |  |  | 1087 | 51.76190476190476 | 0.2588095238095238
 |  | US | 3.890114164960621 |  |  |  | 1260 | 74.7462555448601 | 0.3737312777243006
 |  | US | 13.48353130058385 |  |  |  | 4174.860000000001 | 198.8028571428572 | 0.9940142857142859
 |  | US | 3.428575196236479 |  |  |  | 340 | 22.88476627335003 | 0.1144238313667501
 |  | US | 26.50552363244355 |  |  |  | 3622 | 172.4761904761905 | 0.8623809523809524