Spreadsheet: 870037d1716545155-sumifs-criteria-not-working-v3
Sheet: New Events Campaign

Week Commencing | Date | JCPLocation | DateofEvent | TypeofEvent | DeliveryChannel | NameofEmployer/Provider | No.Employers/Provide | HealthadultSocialCare | Construction | Hospitality | Manufacturing | HaulageLogistics | Other | TotalNo.Vacancies | Number of Interviews | No.ofinterviewsbooked | No.ofinterviewsattended | JoboffersinHealthAdultSocialCare | JoboffersinConstruction | JoboffersinHospitality | JoboffersinManufacturing | JoboffersinHaulageLogistics | joboffersinothersectors | Total Job Offers_x00 | No.ofpotentialoffers | NumberofJobsFairs[I] | NumberofemployersatJobsFair_x005 | NumberofvacanciesatJobsFair_x005 | NumberofcustomersattendingJobsFa | NumberofjoboffersfromJobsFair_x0 | Employersparticipatinginthecampa | NewEmployersParticipatinginCampa | HealthAdultcare | Construction[4] | Hospitality[5] | Manufacturing[6] | HaulageLogistics[7] | Others[8] | NumberofVacancies[S] | NumberofJobsFairs[T] | NumberofJobOffers[U] | EmployerFeedbackComments | MJOupdatedwithrecord | ContentTypeId | Modified | OData__ColorTag | ComplianceAssetId | ID2 | Created | AuthorId | EditorId | OData__UIVersionString | Attachments | GUID
 |  | Fulham | 2024-05-21 23:00:00 | Employer | On Site | City & County HealthCare Group | 1 |  |  |  |  |  |  | 5
 |  | Wandsworth | 2024-05-28 23:00:00 | Employer | Virtual | Quint Education | 1 |  |  |  |  |  |  | 3
 |  | Uxbridge | 2024-05-19 23:00:00 | Employer | On Site | Avon | 1 |  |  |  |  |  |  | 2
 |  | [NAME] | 2024-05-19 23:00:00 | Employer | On Site | Avon | 1 |  |  |  |  |  |  | 2
 |  | [NAME] | 2024-05-20 23:00:00 | Employer | On Site | Capital People | 1 |  |  |  |  |  |  | 4
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | Metroline | 1 |  |  |  |  |  |  | 4
 |  | Uxbridge | 2024-05-23 23:00:00 | Employer | Off Site | GT Recruitment | 1 |  |  |  |  |  |  | 3
 |  | Uxbridge | 2024-05-23 23:00:00 | Employer | Off Site | Sykes and Sons Ltd | 1 |  |  |  |  |  |  | 2
 |  | Hounslow | 2024-05-20 23:00:00 | Jobs Fair | On Site | Metroline Teach Now Kingfisher Classroom Support | 4 |  |  |  |  |  |  | 20
 |  | Hounslow | 2024-05-20 23:00:00 | Provider | On Site | Pathways HRUC | 2 |  |  |  |  |  |  | 10
 |  | [NAME] | 2024-05-19 23:00:00 | Employer | On Site | Plias | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | Mental Health UK | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-27 23:00:00 | Employer | On Site | [NAME] | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-28 23:00:00 | Employer | On Site | Forward Trust | 1 |  |  |  |  |  |  | 5
 |  | Ealing | 2024-05-19 23:00:00 | Group Information Session | On Site | Adecco | 1 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-05-29 23:00:00 | Employer | On Site | [NAME] | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-30 23:00:00 | Employer | On Site | Right at Home | 1 |  |  |  |  |  |  | 1
 |  | Ealing | 2024-05-19 23:00:00 | Provider | On Site | AOFL | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-05-19 23:00:00 | Employer | On Site | Lavish Beauty and Spa | 1 |  |  |  |  |  |  | 2
 |  | Ealing | 2024-05-21 23:00:00 | Employer | On Site | Global Skills Junior Adventures Group | 2 |  |  |  |  |  |  | 5
 |  | Ealing | 2024-06-05 23:00:00 | Employer | On Site | Weaver Rose Estate Agent | 1 |  |  |  |  |  |  | 2
 |  | Ealing | 2024-06-12 23:00:00 | Employer | On Site | MetroLine | 1 |  |  |  |  |  |  | 5
 |  | Ealing | 2024-06-17 23:00:00 | Employer | On Site | Greener Ealing | 1 |  |  |  |  |  |  | 3
 |  | Ealing | 2024-06-13 23:00:00 | Provider | On Site | AOFL | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-06 23:00:00 | Provider | On Site | AOFL | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-20 23:00:00 | Provider | On Site | AFOL | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-27 23:00:00 | Provider | On Site | AOFL | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-05-22 23:00:00 | Employer | On Site | Thames Water | 1 |  |  |  |  |  |  | 8
 |  | Ealing | 2024-05-23 23:00:00 | Employer | On Site | Your World | 1 |  |  |  |  |  |  | 1
 |  | Ealing | 2024-05-28 23:00:00 | Provider | On Site | Making the Leap | 1 |  |  |  |  |  |  | 0
 |  | District Office | 2024-06-05 23:00:00 | Jobs Fair | On Site | 1	Global Skills 2	Oasis Training Agency  3	Enlighten Supply Pool 4	Tesco 5	Smart Works 6	Diffusion Elite Security  7	Metroline Buses | 7 |  |  |  |  |  |  | 80
 |  | [NAME] | 2024-05-21 23:00:00 | Employer | Off Site | Aim Commercial Cleaning | 1 |  |  |  |  |  |  | 2
 |  | [NAME] | 2024-05-22 23:00:00 | Jobs Fair | Off Site | Ikea Primark Livat NHS St. James  St. Williams  London Fire Brigade Omni Group Quint Education | 9 |  |  |  |  |  |  | 40
 |  | [NAME] | 2024-05-29 23:00:00 | Employer | On Site | Home Instead | 1 |  |  |  |  |  |  | 3
 |  | Fulham | 2024-05-29 23:00:00 | Employer | Off Site | Delux Decorator Centre | 1 |  |  |  |  |  |  | 1
 |  | Ealing | 2024-05-29 23:00:00 | Employer | On Site | Qualiteach  Oasis Care  Timpson | 3 |  |  |  |  |  |  | 11
 |  | Wandsworth | 2024-05-20 23:00:00 | Employer | On Site | AFC Wimbledon | 1 |  |  |  |  |  |  | 6
 |  | Wandsworth | 2024-05-21 23:00:00 | Employer | On Site | Ruils | 1 |  |  |  |  |  |  | 3
 |  | Wandsworth | 2024-05-22 23:00:00 | Employer | On Site | WWM Construction | 1 |  |  |  |  |  |  | 6
 |  | Wandsworth | 2024-05-23 23:00:00 | Group Information Session | On Site | NHS | 1 |  |  |  |  |  |  | 9
 |  | Uxbridge | 2024-05-28 23:00:00 | Employer | Off Site | [NAME] | 1 |  |  |  |  |  |  | 1
 |  | Uxbridge | 2024-05-28 23:00:00 | Employer | Off Site | Small Order Springs & Pressings | 1 |  |  |  |  |  |  | 1
 |  | Uxbridge | 2024-05-27 23:00:00 | Employer | Off Site | De Burgh Arms | 1 |  |  |  |  |  |  | 1
 |  | Uxbridge | 2024-05-28 23:00:00 | Employer | Off Site | Home Office | 1 |  |  |  |  |  |  | 4
 |  | [NAME] | 2024-05-27 23:00:00 | Employer | On Site | Home Office | 1 |  |  |  |  |  |  | 4
 |  | Wandsworth | 2024-06-12 23:00:00 | Jobs Fair | On Site | [NAME] UK | 1 |  |  |  |  |  |  | 3
 |  | Wembley | 2024-05-19 23:00:00 | Employer | On Site | First Rung Burleigh College | 2 |  |  |  |  |  |  | 2
 |  | Wembley | 2024-05-19 23:00:00 | Provider | On Site | NCS WHP | 0 |  |  |  |  |  |  | 0
 |  | Harlesden | 2024-05-19 23:00:00 | Provider | On Site | Shaw Trust - Refugee Provision | 0 |  |  |  |  |  |  | 0
 |  | Harlesden | 2024-05-19 23:00:00 | Provider | On Site | NCS | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-05-20 23:00:00 | Employer | On Site | Learning Curve | 1 |  |  |  |  |  |  | 3
 |  | Wembley | 2024-05-20 23:00:00 | Provider | On Site | NCS Smart Works | 0 |  |  |  |  |  |  | 0
 |  | Harlesden | 2024-05-20 23:00:00 | Provider | On Site | Double Espresso | 0 |  |  |  |  |  |  | 0
 |  | Harlesden | 2024-05-20 23:00:00 | Provider | On Site | NCS | 0 |  |  |  |  |  |  | 0
 |  | Harlesden | 2024-05-21 23:00:00 | Provider | On Site | NCS | 0 |  |  |  |  |  |  | 0
 |  | Queens Park | 2024-05-21 23:00:00 | Employer | On Site | PLIAS | 1 |  |  |  |  |  |  | 3
 |  | Harlesden | 2024-05-21 23:00:00 | Job Club | On Site | 0 | 0 |  |  |  |  |  |  | 7
 |  | Harlesden | 2024-05-21 23:00:00 | Employer | On Site | Brent Works | 1 |  |  |  |  |  |  | 5
 |  | Harlesden | 2024-05-21 23:00:00 | Employer | On Site | NCS | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-05-22 23:00:00 | Provider | On Site | MAKING THE LEAP NCS | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-05-22 23:00:00 | Employer | On Site | PLIAS ELEANOR CARE | 2 |  |  |  |  |  |  | 4
 |  | Harlesden | 2024-05-22 23:00:00 | Provider | On Site | REBEL SCHOOL | 0 |  |  |  |  |  |  | 0
 |  | Harlesden | 2024-05-22 23:00:00 | Employer | On Site | BURLEIGH COLLEGE | 1 |  |  |  |  |  |  | 5
 |  | Queens Park | 2024-05-22 23:00:00 | Group Information Session | On Site | REBEL SCHOOL | 0 |  |  |  |  |  |  | 0
 |  | Queens Park | 2024-05-23 23:00:00 | Employer | On Site | HRUC | 1 |  |  |  |  |  |  | 3
 |  | Queens Park | 2024-05-23 23:00:00 | Employer | Off Site | Links Courier | 1 |  |  |  |  |  |  | 7
 |  | Wembley | 2024-05-23 23:00:00 | Employer | On Site | APEX PROJECT | 1 |  |  |  |  |  |  | 3
 |  | Harlesden | 2024-05-23 23:00:00 | Employer | On Site | APEX PROJECT | 1 |  |  |  |  |  |  | 5
 |  | Harlesden | 2024-05-23 23:00:00 | Employer | Virtual | cLASSROOM sUPPORT | 1 |  |  |  |  |  |  | 5
 |  | Harlesden | 2024-05-23 23:00:00 | Employer | Virtual | STEP AHEAD (WORK TRIALS) | 1 |  |  |  |  |  |  | 5
 |  | Wembley | 2024-05-27 23:00:00 | Provider | On Site | NCS | 0 |  |  |  |  |  |  | 0
 |  | Queens Park | 2024-05-26 23:00:00 | Group Information Session | On Site | CLEAN BREAK | 1 |  |  |  |  |  |  | 3
 |  | Wembley | 2024-05-28 23:00:00 | Provider | On Site | HARROW COLLEGE NCS Diffusion Security | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-05-29 23:00:00 | Employer | On Site | PLIAS | 1 |  |  |  |  |  |  | 5
 |  | Wembley | 2024-05-29 23:00:00 | Provider | On Site | NCS MAKINGTHE LEAP CITY OF WESTMINSTER COLLEGE | 0 |  |  |  |  |  |  | 0
 |  | Queens Park | 2024-05-30 23:00:00 | Employer | Virtual | CITY CALLING | 1 |  |  |  |  |  |  | 8
 |  | Hounslow | 2024-05-21 23:00:00 | Provider | On Site | Catch 22 MIT  REP | 3 |  |  |  |  |  |  | 12
 |  | Kingston | 2024-05-23 23:00:00 | Employer | On Site | Protocol Education | 1 |  |  |  |  |  |  | 4
 |  | Uxbridge | 2024-05-29 23:00:00 | Employer | Virtual | Parkside Recruitment | 1 |  |  |  |  |  |  | 0
 |  | Fulham | 2024-05-29 23:00:00 | Employer | Off Site | JobMatcher | 1 |  |  |  |  |  |  | 4
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | Aramark | 1 |  |  |  |  |  |  | 10
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | ABS Care | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | Home Instead | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-23 23:00:00 | Employer | Telephone | Enhanced Catering | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-06-02 23:00:00 | Employer | Telephone | Cross Road Care | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-06-03 23:00:00 | Employer | On Site | Metroline | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-06-05 23:00:00 | Employer | Telephone | Right At Home | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-06-06 23:00:00 | Employer | Telephone | The Lensbury | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-29 23:00:00 | Employer | On Site | MET POLICE | 1 |  |  |  |  |  |  | 5
 |  | [NAME] | 2024-05-21 23:00:00 | Employer | On Site | The Hill Group | 1 |  |  |  |  |  |  | 10
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | [NAME] | 1 |  |  |  |  |  |  | 20
 |  | [NAME] | 2024-05-19 23:00:00 | Employer | On Site | PLIAS | 1 |  |  |  |  |  |  | 5
 |  | Hounslow | 2024-05-26 23:00:00 | Employer | Off Site | Healthcare NHS Trust Call centre | 1 |  |  |  |  |  |  | 1
 |  | Hounslow | 2024-05-30 23:00:00 | Employer | Virtual | Big Issue | 1 |  |  |  |  |  |  | 0
 |  | Hounslow | 2024-05-27 23:00:00 | Provider | On Site | HRUC | 1 |  |  |  |  |  |  | 5
 |  | Hounslow | 2024-05-23 23:00:00 | Provider | On Site | Springboard | 1 |  |  |  |  |  |  | 5
 |  | Hounslow | 2024-05-22 23:00:00 | Provider | On Site | NHS Career Camp | 1 |  |  |  |  |  |  | 10
 |  | [NAME] | 2024-05-22 23:00:00 | Employer | On Site | BlueBird Care | 1 |  |  |  |  |  |  | 0
 |  | Hounslow | 2024-05-28 23:00:00 | Provider | On Site | MIT Work Hounslow | 2 |  |  |  |  |  |  | 15
 |  | [NAME] | 2024-05-20 23:00:00 | Employer | On Site | The Big Issue Recruit | 1 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-05-29 23:00:00 | Employer | On Site | BlueBird Care | 1 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-06-26 23:00:00 | Employer | On Site | Aramark | 1 |  |  |  |  |  |  | 6
 |  | Ealing | 2024-05-21 23:00:00 | Provider | On Site | REP | 0 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-06-19 23:00:00 | Employer | On Site | ABS Care | 1 |  |  |  |  |  |  | 5
 |  | Ealing | 2024-05-22 23:00:00 | Provider | On Site | HRUC Plias | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-17 23:00:00 | Provider | On Site | UCG | 0 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-05-30 23:00:00 | Provider | On Site | AOFL HRUC | 2 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-05-29 23:00:00 | Employer | Off Site | GT Recruitment | 1 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-05-29 23:00:00 | Employer | Off Site | Sykes & Sons | 1 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-05-27 23:00:00 | Provider | On Site | UCG | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-03 23:00:00 | Provider | On Site | UCG | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-10 23:00:00 | Provider | On Site | UCG | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-24 23:00:00 | Provider | On Site | UCG | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-05-29 23:00:00 | Provider | On Site | Plias Strive | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-05-30 23:00:00 | Provider | On Site | AOFL HRUC | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-05 23:00:00 | Provider | On Site | Plias | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-12 23:00:00 | Provider | On Site | Plias | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-19 23:00:00 | Provider | On Site | Plias | 0 |  |  |  |  |  |  | 0
 |  | Ealing | 2024-06-26 23:00:00 | Provider | On Site | Plias | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-05-28 23:00:00 | Employer | On Site | METROLINE BUS COMPANY | 1 |  |  |  |  |  |  | 3
 |  | Wembley | 2024-06-02 23:00:00 | Provider | On Site | NCS WHP & WHP PIONEER PROGRAM | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-06-04 23:00:00 | Employer | On Site | BRENT WORKS | 1 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-06-04 23:00:00 | Provider | On Site | NCS | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-06-05 23:00:00 | Provider | On Site | STRIVE TRAINING NCS | 0 |  |  |  |  |  |  | 0
 |  | Wembley | 2024-06-05 23:00:00 | Employer | On Site | PLIAS | 1 |  |  |  |  |  |  | 0
 |  | [NAME] | 2024-05-30 23:00:00 | Jobs Fair | Off Site | Employers: Ruils Enhance Catering Comfort Care at Home Aramark Starfyn Education St Mary's University Richmond GP Alliance Metroline Metropolitan Police ABM The National Archives Caterlink Supreme Recruitment/ Kingsgate Recruitment Cavan Bakery Clu Abellio Home Office Quint Education [NAME] Bluebird Care Bayley & Sage Full Stop Security Richmond Hill Hotel Bayley & Sage Diffusion Elite Security   Providers:  Social Care Academy Hub Richmond Work Match HRUC DEA Support MTW/ 50+ Support Desk Work Routes Aim2Learn Strive Training [NAME] Microsoft South London Partnership RHACC Smart Works Ziyx The Big Issue Recruit [NAME] | 45 |  |  |  |  |  |  | 250