Spreadsheet: 870048d1716557873-sumifs-criteria-not-working-v3-aligw
Sheet: WEEK2

 | WEEKLY TOTAL
 |  | 2024-05-20 00:00:00 |  |  |  | Today's Date
 |  |  |  |  |  |  |  |  |  |  |  | NO FILTERS |  |  |  |  |  |  |  | FILTER JOBS FAIR |  |  |  |  | FILTER EMPLOYER AND JOBS FAIR
 |  | FILTER EMPLOYER AND JOBS FAIR |  |  |  |  |  |  |  |  |  | job of offers
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs Available slots |  | Offers Vs Attended
 | WEEKLY TOTAL BROKEN DOWN INTO DAYS
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 | IMPUT YOUR OWN DATES
 |  | 2024-05-20 00:00:00 | TO | 2024-05-26 00:00:00
 | SITE | Total number of employers | Health & Adult Social Care | Construction | Hospitality | Manufacturing | Haulage & Logistics | Other | Total number of vacancies [E] | Number of Interview's available [F] | Number of interviews Attended [G] | Health & Adult Social Care [2] | Construction [3] | Hospitality [4] | Manufacturing [5] | Haulage & Logistics [6] | Other [7] | Total Job Offers [H] | Number of Jobs Fairs [I] | Number of employers at Jobs Fair [J] | Number of vacancies at Jobs Fair [K] | Number of customers attending Jobs Fair [L] | Number of job offers from Jobs Fair [M] | Number of Employers Participating in Campaign [N] | New Employers Participating in Campaign [O] | Health & Adult Social Care [3] | Construction [4] | Hospitality [5] | Manufacturing [6] | Haulage & Logistics [7] | Other [8] | Number of Vacancies [S] | Number of Jobs Fairs [T] | Number of Job Offers [U] |  | MJ&O updated TRUE | MJ&O updated FALSE
 | [NAME]
 | Ealing
 | Fulham
 | Harlesden
 | [NAME]
 | [NAME]
 | Hounslow
 | Kingston
 | Queens Park
 | [NAME]
 | [NAME]
 | Uxbridge
 | Wandsworth
 | Wembley
 | OTHERS
 | District Office
 | [NAME]
 | TOTAL
 |  |  |  |  |  |  | Offers Vs Vacancies |  |  | Attended Vs AvaJlable slots |  | Offers Vs Attended
 |  |  |  |  |  | TABLE3[Date],">="&WEEK2!$C219,TABLE3[Date],"<="&WEEK2!$E219,