Spreadsheet: 755167d1636707569-sum-ifs-not-adding-up-correctly-test
Sheet: Sheet1

 |  |  | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 |  |  |  |  |  |  |  |  | YTD
 | [NAME] | Referrals Profile | 54.70746545446323 | 61.93297975976968 | 47.57170909083759 | 54.70746545446323
 |  | Referrals Achived | 36 | 21 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.6580454733360892 | 0.339076209177346 | 0 | 0
 |  | Starts Profile | 32.82447927267793 | 32.82447927267793 | 32.82447927267793 | 32.82447927267793
 |  | Starts Achieved | 24 | 3 | 0 | 0
 |  | Start Profile vs Achieved | 0.7311616370400991 | 0.09139520463001238 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.6666666666666666 | 0.1428571428571428 | - | -
 | Ealing | Referrals Profile | 108.1936811633535 | 122.4834126377586 | 94.08146188117693 | 108.1936811633535
 |  | Referrals Achived | 106 | 21 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.9797244983277591 | 0.1714517872073579 | 0 | 0
 |  | Starts Profile | 64.91620869801208 | 64.91620869801208 | 64.91620869801208 | 64.91620869801208
 |  | Starts Achieved | 75 | 9 | 0 | 0
 |  | Start Profile vs Achieved | 1.155335493311037 | 0.1386402591973244 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.7075471698113207 | 0.4285714285714285 | - | -
 | Fulham | Referrals Profile | 66.37718524549382 | 75.14398329678545 | 57.71929151782071 | 66.37718524549382
 |  | Referrals Achived | 32 | 8 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.4820933560477002 | 0.1064622827938671 | 0 | 0
 |  | Starts Profile | 39.82631114729629 | 39.82631114729629 | 39.82631114729629 | 39.82631114729629
 |  | Starts Achieved | 16 | 6 | 0 | 0
 |  | Start Profile vs Achieved | 0.4017444633730835 | 0.1506541737649063 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.5 | 0.75 | - | -
 | Harlesden | Referrals Profile | 130.1083293755795 | 147.2924483497127 | 113.1376777178953 | 130.1083293755795
 |  | Referrals Achived | 137 | 44 | 0 | 0
 |  | Ref. Profile vs Achieved | 1.05296871197636 | 0.2987254302103251 | 0 | 0
 |  | Starts Profile | 78.06499762534771 | 78.06499762534771 | 78.06499762534771 | 78.06499762534771
 |  | Starts Achieved | 50 | 18 | 0 | 0
 |  | Start Profile vs Achieved | 0.6404919172605598 | 0.2305770902138015 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.364963503649635 | 0.4090909090909091 | - | -
 | [NAME] | Referrals Profile | 71.5788045321935 | 81.03260890437 | 62.24243872364653 | 71.5788045321935
 |  | Referrals Achived | 74 | 32 | 0 | 0
 |  | Ref. Profile vs Achieved | 1.033825592417062 | 0.3949027488151659 | 0 | 0
 |  | Starts Profile | 42.9472827193161 | 42.9472827193161 | 42.9472827193161 | 42.9472827193161
 |  | Starts Achieved | 40 | 12 | 0 | 0
 |  | Start Profile vs Achieved | 0.9313744075829384 | 0.2794123222748815 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.5405405405405406 | 0.375 | - | -
 | [NAME] | Referrals Profile | 41.83911165388878 | 47.36503206100615 | 36.38183622077285 | 41.83911165388878
 |  | Referrals Achived | 27 | 3 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.6453291891891891 | 0.06333786486486487 | 0 | 0
 |  | Starts Profile | 25.10346699233327 | 25.10346699233327 | 25.10346699233327 | 25.10346699233327
 |  | Starts Achieved | 22 | 2 | 0 | 0
 |  | Start Profile vs Achieved | 0.8763729729729729 | 0.07967027027027027 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.8148148148148148 | 0.6666666666666666 | - | -
 | Hounslow | Referrals Profile | 101.5785783748332 | 114.9946170281131 | 88.32919858681149 | 101.5785783748332
 |  | Referrals Achived | 73 | 13 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.7186554603139262 | 0.1130487698986976 | 0 | 0
 |  | Starts Profile | 60.94714702489992 | 60.94714702489992 | 60.94714702489992 | 60.94714702489992
 |  | Starts Achieved | 51 | 5 | 0 | 0
 |  | Start Profile vs Achieved | 0.8367906044751198 | 0.08203829455638428 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.6986301369863014 | 0.3846153846153846 | - | -
 | Kingston | Referrals Profile | 49.45480459439714 | 49.08073866321185 | 43.19362362582856 | 58.60503275723713
 |  | Referrals Achived | 45 | 21 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.9099217026346954 | 0.4278664211657519 | 0 | 0
 |  | Starts Profile | 29.67288275663828 | 26.01279149150228 | 29.80360030182171 | 35.16301965434228
 |  | Starts Achieved | 26 | 11 | 0 | 0
 |  | Start Profile vs Achieved | 0.8762208988334105 | 0.4228688798583351 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.5777777777777777 | 0.5238095238095238 | - | -
 | [NAME] | Referrals Profile | 31.56025962864961 | 35.72859580601843 | 27.44370402491271 | 31.56025962864961
 |  | Referrals Achived | 8 | 9 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.2534833393049086 | 0.251899068434253 | 0 | 0
 |  | Starts Profile | 18.93615577718977 | 18.93615577718977 | 18.93615577718977 | 18.93615577718977
 |  | Starts Achieved | 5 | 1 | 0 | 0
 |  | Start Profile vs Achieved | 0.2640451451092798 | 0.05280902902185597 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.625 | 0.1111111111111111 | - | -
 | [NAME] | Referrals Profile | 35.28990454289582 | 35.02297899112094 | 30.82205798038784 | 41.81931419400429
 |  | Referrals Achived | 32 | 12 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.9067749095524797 | 0.3426321902269436 | 0 | 0
 |  | Starts Profile | 21.17394272573749 | 18.5621788652941 | 21.26722000646761 | 25.09158851640257
 |  | Starts Achieved | 17 | 3 | 0 | 0
 |  | Start Profile vs Achieved | 0.802873617832925 | 0.1616189576542187 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.53125 | 0.25 | - | -
 | Uxbridge | Referrals Profile | 43.73883348033562 | 49.51566054377616 | 38.0337682437701 | 43.73883348033562
 |  | Referrals Achived | 48 | 3 | 0 | 0
 |  | Ref. Profile vs Achieved | 1.097422957600827 | 0.06058689245087902 | 0 | 0
 |  | Starts Profile | 26.24330008820137 | 26.24330008820137 | 26.24330008820137 | 26.24330008820137
 |  | Starts Achieved | 39 | 4 | 0 | 0
 |  | Start Profile vs Achieved | 1.486093588417787 | 0.1524198552223371 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.8125 | 1.333333333333333 | - | -
 | Wandsworth | Referrals Profile | 82.90797200625103 | 60.10386030303913 | 60.10386030303913 | 60.10386030303913
 |  | Referrals Achived | 39 | 9 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.4704010851581258 | 0.1497407979225075 | 0 | 0
 |  | Starts Profile | 41.45398600312551 | 30.05193015151956 | 30.05193015151956 | 30.05193015151956
 |  | Starts Achieved | 25 | 4 | 0 | 0
 |  | Start Profile vs Achieved | 0.6030783143052895 | 0.1331029314866733 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.6410256410256411 | 0.4444444444444444 | - | -
 | Wembley | Referrals Profile | 51.37164439016668 | 58.15657855490566 | 44.67099512188407 | 51.37164439016668
 |  | Referrals Achived | 22 | 7 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.4282518159806295 | 0.1203647149460709 | 0 | 0
 |  | Starts Profile | 30.8229866341 | 30.8229866341 | 30.8229866341 | 30.8229866341
 |  | Starts Achieved | 12 | 3 | 0 | 0
 |  | Start Profile vs Achieved | 0.3893198327096632 | 0.09732995817741581 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.5454545454545454 | 0.4285714285714285 | - | -
 | West London | Referrals Profile | 868.7065744425015 | 937.8534948995878 | 743.7316230387837 | 861.5821005532381
 |  | Referrals Achived | 679 | 203 | 0 | 0
 |  | Ref. Profile vs Achieved | 0.7816218041583868 | 0.2164517177832071 | 0 | 0
 |  | Starts Profile | 512.9331474648757 | 495.2592364876904 | 501.7550864391833 | 510.9388743016389
 |  | Starts Achieved | 402 | 81 | 0 | 0
 |  | Start Profile vs Achieved | 0.7837278639270002 | 0.1635507104813244 | 0 | 0
 |  | Referrals vs Starts Ratio | 0.5920471281296024 | 0.3990147783251232 | - | -
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow | Referrals Profile |  |  |  | CORRECT
 | Kingston | Referrals Achived |  |  |  | INCOORECT
 | [NAME] | Ref. Profile vs Achieved |  |  |  | INCOORECT
 | [NAME] | Starts Profile |  |  |  | INCOORECT
 | Uxbridge | Starts Achieved |  |  |  | INCOORECT
 | Wandsworth | Start Profile vs Achieved |  |  |  | INCOORECT
 | Wembley | Referrals vs Starts Ratio |  |  |  | INCOORECT
 | West London