Spreadsheet: 756186d1637327592-looking-up-data-in-a-range-and-adding-up-together-book1-copy
Sheet: Sheet1

 |  |  | [NAME] and Starts
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  | UPDATED ON JETS Starts Raw Data
 |  | Uxbridge |  |  |  |  |  | UPDATED ON 11-10-2021
 |  |  | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | YTD
a |  | Referrals Profile | 54.70746545446323 | 61.93297975976968 | 47.57170909083759 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 54.70746545446323 | 656.5793433952394
a |  | Referrals Achived | 36 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66
a |  | Ref. Profile vs Achieved | 0.6580454733360892 | 0.4843945845390657 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1005209814532197
a |  | Starts Profile | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 393.8937512721352
a |  | Starts Achieved | 23 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34
a |  | Start Profile vs Achieved | 0.700696568830095 | 0.3351157503100454 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08631769326167837
a |  | Referrals vs Starts Ratio | 1.565217391304348 | 2.727272727272727 | - | - | - | - | - | - | - | - | - | - | 1.941176470588235
b |  | Referrals Profile | 108.1936811633535 | 122.4834126377586 | 94.08146188117693 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 108.1936811633535 | 1298.50168615247
b |  | Referrals Achived | 106 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 156
b |  | Ref. Profile vs Achieved | 0.9797244983277591 | 0.4082185409698997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1201384654818865
b |  | Starts Profile | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 778.9945043761448
b |  | Starts Achieved | 75 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 97
b |  | Start Profile vs Achieved | 1.155335493311037 | 0.3388984113712374 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1245194920568562
b |  | Referrals vs Starts Ratio | 0.7075471698113207 | 0.44 | - | - | - | - | - | - | - | - | - | - | 0.6217948717948718
c |  | Referrals Profile | 66.37718524549382 | 75.14398329678545 | 57.71929151782071 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 66.37718524549382 | 796.6351272695443
c |  | Referrals Achived | 32 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46
c |  | Ref. Profile vs Achieved | 0.4820933560477002 | 0.1863089948892675 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05774287176823893
c |  | Starts Profile | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 477.9157337675554
c |  | Starts Achieved | 16 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26
c |  | Start Profile vs Achieved | 0.4017444633730835 | 0.2510902896081772 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05440289608177173
c |  | Referrals vs Starts Ratio | 0.5 | 0.7142857142857143 | - | - | - | - | - | - | - | - | - | - | 0.5652173913043478
d |  | Referrals Profile | 130.1083293755795 | 147.2924483497127 | 113.1376777178953 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 130.1083293755795 | 1561.513419823403
d |  | Referrals Achived | 137 | 98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 235
d |  | Ref. Profile vs Achieved | 1.05296871197636 | 0.6653430036502695 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1504950242608718
d |  | Starts Profile | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 936.7799715041725
d |  | Starts Achieved | 50 | 49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 99
d |  | Start Profile vs Achieved | 0.6404919172605598 | 0.6276820789153486 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1056811663479924
d |  | Referrals vs Starts Ratio | 0.364963503649635 | 0.5 | - | - | - | - | - | - | - | - | - | - | 0.4212765957446808
e |  | Referrals Profile | 71.5788045321935 | 81.03260890437 | 62.24243872364653 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 71.5788045321935 | 859.0630929499517
e |  | Referrals Achived | 74 | 63 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 137
e |  | Ref. Profile vs Achieved | 1.033825592417062 | 0.7774647867298579 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1594760630788518
e |  | Starts Profile | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 515.3673926317932
e |  | Starts Achieved | 40 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 70
e |  | Start Profile vs Achieved | 0.9313744075829384 | 0.6985308056872038 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1358254344391785
e |  | Referrals vs Starts Ratio | 0.5405405405405406 | 0.4761904761904762 | - | - | - | - | - | - | - | - | - | - | 0.5109489051094891
f |  | Referrals Profile | 41.83911165388878 | 47.36503206100615 | 36.38183622077285 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 41.83911165388878 | 502.1379848206668
f |  | Referrals Achived | 27 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
f |  | Ref. Profile vs Achieved | 0.6453291891891891 | 0.06333786486486487 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05974453418558681
f |  | Starts Profile | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 301.2416039079992
f |  | Starts Achieved | 22 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26
f |  | Start Profile vs Achieved | 0.8763729729729729 | 0.1593405405405405 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.08630945945945945
f |  | Referrals vs Starts Ratio | 0.8148148148148148 | 1.333333333333333 | - | - | - | - | - | - | - | - | - | - | 0.8666666666666667
g |  | Referrals Profile | 101.5785783748332 | 114.9946170281131 | 88.32919858681149 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 101.5785783748332 | 1219.109599363257
g |  | Referrals Achived | 73 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 129
g |  | Ref. Profile vs Achieved | 0.7186554603139262 | 0.4869793164866971 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1058149325272945
g |  | Starts Profile | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 731.3657642987988
g |  | Starts Achieved | 51 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 64
g |  | Start Profile vs Achieved | 0.8367906044751198 | 0.2132995658465991 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0875075141934766
g |  | Referrals vs Starts Ratio | 0.6986301369863014 | 0.2321428571428572 | - | - | - | - | - | - | - | - | - | - | 0.4961240310077519
h |  | Referrals Profile | 49.45480459439714 | 49.08073866321185 | 43.19362362582856 | 58.60503275723713 | 55.77281927826284 | 54.90136897703999 | 54.68350640173428 | 47.05831626603428 | 44.00824021175428 | 26.14350903668571 | 20.91480722934857 | 18.30045632568 | 522.1172233672147
h |  | Referrals Achived | 45 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80
h |  | Ref. Profile vs Achieved | 0.9099217026346954 | 0.7131107019429197 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1532222964874969
h |  | Starts Profile | 29.67288275663828 | 26.01279149150228 | 29.80360030182171 | 35.16301965434228 | 33.46369156695771 | 32.94082138622399 | 32.81010384104056 | 28.23498975962056 | 26.40494412705257 | 15.68610542201142 | 12.54888433760914 | 10.980273795408 | 313.7221084402285
h |  | Starts Achieved | 26 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42
h |  | Start Profile vs Achieved | 0.8762208988334105 | 0.6150820070666693 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1338764431006047
h |  | Referrals vs Starts Ratio | 0.5777777777777777 | 0.4571428571428571 | - | - | - | - | - | - | - | - | - | - | 0.525
i |  | Referrals Profile | 31.56025962864961 | 35.72859580601843 | 27.44370402491271 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 31.56025962864961 | 378.7748961174272
i |  | Referrals Achived | 8 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23
i |  | Ref. Profile vs Achieved | 0.2534833393049086 | 0.419831780723755 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.06072208120379122
i |  | Starts Profile | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 227.2338693262772
i |  | Starts Achieved | 5 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
i |  | Start Profile vs Achieved | 0.2640451451092798 | 0.1584270870655679 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.03520601934790399
i |  | Referrals vs Starts Ratio | 0.625 | 0.2 | - | - | - | - | - | - | - | - | - | - | 0.3478260869565217
j |  | Referrals Profile | 35.28990454289582 | 35.02297899112094 | 30.82205798038784 | 41.81931419400429 | 39.79830644485167 | 39.17645790665086 | 39.02099577210066 | 33.57982106284359 | 31.40335117914077 | 18.65545614602422 | 14.92436491681937 | 13.05881930221695 | 372.571828439057
j |  | Referrals Achived | 32 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65
j |  | Ref. Profile vs Achieved | 0.9067749095524797 | 0.9422385231240951 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1744630029391294
j |  | Starts Profile | 21.17394272573749 | 18.5621788652941 | 21.26722000646761 | 25.09158851640257 | 23.878983866911 | 23.50587474399051 | 23.41259746326039 | 20.14789263770616 | 18.84201070748446 | 11.19327368761453 | 8.954618950091625 | 7.835291581330171 | 223.8654737522906
j |  | Starts Achieved | 16 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
j |  | Start Profile vs Achieved | 0.7556457579604 | 0.6464758306168747 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1250751155624037
j |  | Referrals vs Starts Ratio | 0.5 | 0.3636363636363636 | - | - | - | - | - | - | - | - | - | - | 0.4307692307692308
k |  | Referrals Profile | 43.73883348033562 | 49.51566054377616 | 38.0337682437701 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 43.73883348033562 | 524.9377635909026
k |  | Referrals Achived | 48 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 58
k |  | Ref. Profile vs Achieved | 1.097422957600827 | 0.2019563081695967 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1104892884886843
k |  | Starts Profile | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 314.9196010584164
k |  | Starts Achieved | 39 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48
k |  | Start Profile vs Achieved | 1.486093588417787 | 0.3429446742502585 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1524198552223371
k |  | Referrals vs Starts Ratio | 0.8125 | 0.9 | - | - | - | - | - | - | - | - | - | - | 0.8275862068965517
l |  | Referrals Profile | 82.90797200625103 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913 | 744.0504353396815
l |  | Referrals Achived | 39 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 55
l |  | Ref. Profile vs Achieved | 0.4704010851581258 | 0.2662058629733466 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.07391972020672341
l |  | Starts Profile | 41.45398600312551 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956 | 372.0252176698407
l |  | Starts Achieved | 25 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36
l |  | Start Profile vs Achieved | 0.6030783143052895 | 0.3660330615883516 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.09676763372516518
l |  | Referrals vs Starts Ratio | 0.6410256410256411 | 0.6875 | - | - | - | - | - | - | - | - | - | - | 0.6545454545454545
m |  | Referrals Profile | 51.37164439016668 | 58.15657855490566 | 44.67099512188407 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 51.37164439016668 | 616.5440175784566
m |  | Referrals Achived | 22 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34
m |  | Ref. Profile vs Achieved | 0.4282518159806295 | 0.2063395113361216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05514610316638653
m |  | Starts Profile | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341 | 369.8758396092001
m |  | Starts Achieved | 12 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21
m |  | Start Profile vs Achieved | 0.3893198327096632 | 0.2919898745322475 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05677580893682589
m |  | Referrals vs Starts Ratio | 0.5454545454545454 | 0.75 | - | - | - | - | - | - | - | - | - | - | 0.6176470588235294
 |  | Referrals Profile | 868.7065744425015 | 937.8534948995878 | 743.7316230387837 | 861.5821005532381 | 856.7288793251112 | 855.2355804856875 | 854.8622557758316 | 841.7958909308745 | 836.5693449928916 | 805.9567187847066 | 796.9969257481646 | 792.5170292298936 | 10052.53641820727
 |  | Referrals Achived | 679 | 435 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1114
 |  | Ref. Profile vs Achieved | 0.7816218041583868 | 0.4638251095354437 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1108178029559097
 |  | Starts Profile | 512.9331474648757 | 495.2592364876904 | 501.7550864391833 | 510.9388743016389 | 508.0269415647627 | 507.1309622611085 | 506.906967435195 | 499.0671485282207 | 495.931220965431 | 477.56364524052 | 472.1877694185948 | 469.4998315076322 | 5957.200831614852
 |  | Starts Achieved | 400 | 199 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 599
 |  | Start Profile vs Achieved | 0.7798287203253733 | 0.4018097701948586 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1005505802022165
 |  | Referrals vs Starts Ratio | 0.5891016200294551 | 0.4574712643678161 | - | - | - | - | - | - | - | - | - | - | 0.5377019748653501
 |  | DROP DOWN MENU
 |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  | [NAME] | Ealing [NAME] | [NAME] House [NAME] | [NAME] | Harrow Kings House [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Twickenham Jobcentre Plus | Uxbridge Jobcentre Plus | Wandsworth Arndale House Jobcentre Plus | [NAME]
 |  |  | a | b | c | d | f | g | h | i | j | k | l | m | n | TOTAL
 |  | Referrals | SUMPRODUCT(INDEX($D$26:$O128,MATCH(C$183,$C$26:$C$128,0),)*($D$25:$O$25>=$C$180)*($D$25:$O$25<=EOMONTH($D$180,0))*($D$26:$O128,MATCH(D$182,$A$26:$A$128,0)) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | #N/A
 |  | Starts | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Referrals to Starts Ratio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23