Spreadsheet: 746199d1630574561-sumifs-not-working-but-same-formula-working-else-where-book1
Sheet: KS Vacancies vs Starts

 |  |  |  |  |  |  |  | UPDATED ON 31-08-2021
 | DROP DOWN MENU
 | Ealing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01/01/20222
 | . |  | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | YTD
 | ACTON | Total Number of clmt | 12915 | 26139 | 26304 | 34013 | 20650 | 27158 | 28784 | 36800 | 29810 | 35412 | 26480 | 26379 | 26228 | 357072
 |  | 25+ clmt | 10963 | 22231 | 22407 | 29076 | 17614 | 23086 | 24615 | 31428 | 25555 | 30559 | 23002 | 23083 | 22977 | 306596
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8488579171506001 | 0.850491602586174 | 0.8518476277372263 | 0.8548496163231706 | 0.8529782082324455 | 0.8500625966566021 | 0.8551625903279599 | 0.8540217391304348 | 0.8572626635357262 | 0.8629560600926239 | 0.8686555891238671 | 0.8750521247962394 | 0.8760484977886228 | 0.8586391540081553
 | EALING | Total Number of clmt | 25327 | 50544 | 51345 | 66241 | 40001 | 52768 | 55745 | 71195 | 57275 | 68550 | 52418 | 52206 | 51169 | 694784
 |  | 25+ clmt | 21613 | 42985 | 43655 | 56258 | 33772 | 44546 | 47532 | 60542 | 48981 | 58942 | 45297 | 45484 | 44794 | 594401
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8533580763611955 | 0.8504471351693574 | 0.8502288440938748 | 0.8492927341072749 | 0.8442788930276743 | 0.8441858702243784 | 0.8526684007534308 | 0.8503687056675329 | 0.8551898734177216 | 0.8598395331874544 | 0.8641497195619825 | 0.8712408535417385 | 0.875412847622584 | 0.8555191253684599
 | FULHAM | Total Number of clmt | 15557 | 31302 | 31728 | 41011 | 24986 | 33100 | 34260 | 43566 | 34860 | 41773 | 31626 | 30923 | 30006 | 424698
 |  | 25+ clmt | 13467 | 27034 | 27398 | 35519 | 21641 | 28607 | 29706 | 37698 | 30321 | 36450 | 27796 | 27430 | 26712 | 369779
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8656553320048853 | 0.8636508849274807 | 0.8635274836106909 | 0.8660847089805174 | 0.8661250300168094 | 0.8642598187311178 | 0.8670753064798599 | 0.8653078088417573 | 0.8697934595524957 | 0.8725731932109257 | 0.8788971099728072 | 0.887042007567183 | 0.8902219556088782 | 0.8706869351868858
 | HARLESDEN | Total Number of clmt | 28209 | 57747 | 58801 | 75585 | 45882 | 61461 | 65212 | 84162 | 67515 | 80724 | 61906 | 60924 | 59821 | 807949
 |  | 25+ clmt | 24047 | 49211 | 50093 | 64352 | 39018 | 52181 | 55634 | 71550 | 57488 | 69096 | 53250 | 52742 | 51800 | 690462
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8524584352511609 | 0.8521827973747554 | 0.8519072804884271 | 0.8513858569822055 | 0.8503988492219171 | 0.8490099412635655 | 0.8531251916825124 | 0.8501461467170457 | 0.8514848552173591 | 0.8559536197413409 | 0.8601751041902239 | 0.8657015297748014 | 0.8659166513431737 | 0.8545861186782829
 | HARROW | Total Number of clmt | 18816 | 37149 | 37119 | 47895 | 29169 | 38304 | 40517 | 51676 | 41476 | 48590 | 36285 | 36244 | 35356 | 498596
 |  | 25+ clmt | 15729 | 30961 | 30892 | 39796 | 24255 | 31650 | 33882 | 43203 | 34879 | 40936 | 30837 | 31198 | 30488 | 418706
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8359375 | 0.8334275485208216 | 0.8322422479053854 | 0.8309009291157741 | 0.8315334773218143 | 0.8262844611528822 | 0.8362415776093985 | 0.8360360709033207 | 0.840944160478349 | 0.8424778761061947 | 0.8498553121124431 | 0.8607769561858515 | 0.8623147414865935 | 0.8397700743688277
 | HAYES | Total Number of clmt | 9786 | 19562 | 19808 | 25806 | 15624 | 20860 | 21941 | 28065 | 22437 | 26472 | 20166 | 19956 | 19572 | 270055
 |  | 25+ clmt | 8189 | 16322 | 16424 | 21337 | 12875 | 17117 | 18188 | 23245 | 18739 | 22150 | 16962 | 16959 | 16669 | 225176
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8368076844471695 | 0.8343727635211123 | 0.8291599353796446 | 0.8268232194063396 | 0.82405273937532 | 0.8205656759348035 | 0.8289503668930314 | 0.8282558346695172 | 0.8351829567232696 | 0.8367331520096706 | 0.8411187146682535 | 0.8498196031268791 | 0.8516758634784386 | 0.8338153339134621
 | HOUNSLOW | Total Number of clmt | 24336 | 49037 | 49845 | 64853 | 39141 | 51507 | 54997 | 70434 | 56592 | 67132 | 50728 | 49723 | 48581 | 676906
 |  | 25+ clmt | 20668 | 41521 | 42071 | 54733 | 32950 | 43387 | 46704 | 59705 | 48115 | 57049 | 43187 | 42668 | 41821 | 574579
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8492767915844839 | 0.8467279809123723 | 0.8440365131908918 | 0.8439547900636825 | 0.8418282619248358 | 0.8423515250354321 | 0.8492099569067404 | 0.8476729988357895 | 0.8502085100367544 | 0.8498033724602276 | 0.8513444251695316 | 0.8581139512901474 | 0.8608509499598609 | 0.8488313000623425
 | KINGSTON | Total Number of clmt | 11749 | 22959 | 22393 | 28583 | 17203 | 22285 | 23550 | 29931 | 24028 | 27961 | 20943 | 20831 | 20476 | 292892
 |  | 25+ clmt | 9858 | 19217 | 18635 | 23751 | 14301 | 18416 | 19655 | 25008 | 20079 | 23421 | 17703 | 17789 | 17605 | 245438
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8390501319261213 | 0.8370138072215689 | 0.8321796990130844 | 0.8309484658713221 | 0.8313084927047608 | 0.8263854610724702 | 0.8346072186836518 | 0.8355216999097925 | 0.835650074912602 | 0.8376309860162369 | 0.8452943704340352 | 0.8539676443761701 | 0.8597870677866771 | 0.8379812354041762
 | SHEPHERDSBUSH | Total Number of clmt | 7536 | 15297 | 15261 | 20123 | 12052 | 16129 | 16762 | 21376 | 16900 | 20289 | 15462 | 14808 | 14446 | 206441
 |  | 25+ clmt | 6272 | 12722 | 12754 | 16889 | 10047 | 13453 | 14053 | 17963 | 14280 | 17288 | 13185 | 12797 | 12519 | 174222
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.832271762208068 | 0.8316663398051906 | 0.8357250507830417 | 0.8392883764846196 | 0.8336375705277133 | 0.8340876681753363 | 0.8383844409974943 | 0.8403349550898204 | 0.8449704142011835 | 0.8520873379663857 | 0.8527357392316647 | 0.8641950297136682 | 0.8666066731275094 | 0.843931195838036
 | TWICKENHAM | Total Number of clmt | 8443 | 16829 | 16538 | 21010 | 12800 | 16528 | 17267 | 22008 | 17668 | 20744 | 15448 | 15011 | 14651 | 214945
 |  | 25+ clmt | 6951 | 13926 | 13666 | 17371 | 10615 | 13676 | 14429 | 18373 | 14863 | 17577 | 13245 | 13101 | 12917 | 180710
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.823285562004027 | 0.8275001485530928 | 0.8263393397025033 | 0.8267967634459781 | 0.829296875 | 0.8274443368828654 | 0.8356402386054324 | 0.8348327880770628 | 0.8412383971021055 | 0.8473293482452757 | 0.8573925427239772 | 0.8727599760175871 | 0.8816463040065524 | 0.8407266975272745
 | UXBRIDGE | Total Number of clmt | 11723 | 23208 | 23338 | 29898 | 18033 | 24078 | 25292 | 31999 | 25596 | 30205 | 22614 | 22162 | 21902 | 310048
 |  | 25+ clmt | 9578 | 18811 | 18850 | 24010 | 14396 | 19236 | 20346 | 25718 | 20623 | 24456 | 18499 | 18340 | 18217 | 251080
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8170263584406722 | 0.8105394691485694 | 0.8076956037363956 | 0.8030637500836176 | 0.7983142017412521 | 0.7989035634188886 | 0.804444092993832 | 0.8037126160192506 | 0.8057118299734334 | 0.8096672736301936 | 0.8180330768550456 | 0.8275426405559065 | 0.831750525066204 | 0.8098100939209413
 | WANDSWORTH | Total Number of clmt | 13548 | 26790 | 26934 | 34393 | 21063 | 27927 | 29369 | 37139 | 29600 | 34790 | 25804 | 25076 | 24407 | 356840
 |  | 25+ clmt | 11360 | 22393 | 22543 | 28658 | 17530 | 23178 | 24530 | 31092 | 24842 | 29329 | 21931 | 21434 | 20886 | 299706
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8385001476232654 | 0.8358715938783128 | 0.8369718571322492 | 0.8332509522286512 | 0.832265109433604 | 0.8299495112256956 | 0.8352344308624741 | 0.8371792455370365 | 0.8392567567567567 | 0.8430296062086806 | 0.8499069911641606 | 0.8547615249641091 | 0.855738107919859 | 0.8398890258939581
 | WEMBLEY | Total Number of clmt | 12577 | 25553 | 25705 | 33394 | 20475 | 27055 | 28637 | 36805 | 29509 | 34905 | 26167 | 25839 | 25344 | 351965
 |  | 25+ clmt | 10677 | 21574 | 21687 | 28097 | 17179 | 22679 | 24161 | 30935 | 24919 | 29536 | 22301 | 22183 | 21789 | 297717
 |  | Ratio: Total Number of clmt to 25+ clmt | 0.8489305875805041 | 0.8442844284428442 | 0.8436879984438825 | 0.8413786907827754 | 0.839023199023199 | 0.8382554056551469 | 0.8436987114572058 | 0.8405108001630214 | 0.8444542343013995 | 0.8461824953445065 | 0.8522566591508388 | 0.8585084562096056 | 0.8597301136363636 | 0.8458710383134687
 | WEST LONDON | Total Number of clmt
 |  | 25+ clmt
 |  | Ratio: Total Number of clmt to 25+ clmt
 | Office_Name
 | [NAME]
 | Ealing
 | Fulham
 | HARLESDEN
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 |  |  | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | YTD
[NAME]  working |  | Total Number of clmt
[NAME] NOT working |  | 25+ clmt
 |  | Ratio: Total Number of clmt to 25+ clmt