Spreadsheet: 26996d1219761016-sumif-with-multiple-criteria-not-sure-what-functions-to-use-trend-graph1-rev2
Sheet: w.e. 29th june

 |  | Mon 23/Jun | Tue 24/Jun | Wed 25/Jun | Thu 26/Jun | Fri 27/Jun | Sat 28/Jun | Sun 29/Jun | 7 DAY TOTAL
 | Emergency | 3 | 5 | 3 | 3 | 7 | 3 | 4 | 28
 | Specialist Inspection: Asbestos |  |  | 1 |  |  |  |  | 1
 | Specialist Inspection: Roof | 3 | 2 | 1 | 1 | 2 |  |  | 9
 | Specialist Inspection: Trace & Access | 5 | 5 | 3 | 3 | 4 |  |  | 20
 | Works | 36 | 35 | 27 | 40 | 26 |  |  | 164
 | TOTAL | 47 | 47 | 35 | 47 | 39 | 3 | 4 | 222
 |  |  | Mon 23/Jun | Tue 24/Jun | Wed 25/Jun | Thu 26/Jun | Fri 27/Jun | Sat 28/Jun | Sun 29/Jun | 7 DAY TOTAL
#N/A | AL | Emergency | 1 |  | 1 |  | 1 | 1 |  | 4
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access |  | 1 | 1 |  |  |  |  | 2
#N/A |  | Works |  | 2 | 1 | 3 | 2 |  |  | 8
st albans |  | AL | 1 | 3 | 3 | 3 | 3 | 1 |  | 14
#N/A | CB | Emergency |  | 1 |  |  |  |  | 1 | 2
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof |  |  | 1 |  |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access | 1 |  |  |  |  |  |  | 1
#N/A |  | Works | 1 |  | 1 |  | 1 |  |  | 3
peterborough |  | CB | 2 | 1 | 2 |  | 1 |  | 1 | 7
#N/A | HA | Emergency
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof |  |  |  |  | 1 |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access |  |  |  |  | 1 |  |  | 1
#N/A |  | Works | 1 | 5 | 1 | 1 | 3 |  |  | 11
st albans |  | HA | 1 | 5 | 1 | 1 | 5 |  |  | 13
#N/A | HP | Emergency
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access | 1 |  | 1 |  | 1 |  |  | 3
#N/A |  | Works | 3 | 4 | 3 | 4 | 2 |  |  | 16
st albans |  | HP | 4 | 4 | 4 | 4 | 3 |  |  | 19
#N/A | IP | Emergency |  | 1 |  | 1 |  |  |  | 2
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof | 1 |  |  |  |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access | 1 |  |  |  | 1 |  |  | 2
#N/A |  | Works | 1 | 7 | 2 | 4 |  |  |  | 14
peterborough |  | IP | 3 | 8 | 2 | 5 | 1 |  |  | 19
#N/A | LU | Emergency
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access
#N/A |  | Works | 2 | 1 | 2 | 2 | 2 |  |  | 9
st albans |  | LU | 2 | 1 | 2 | 2 | 2 |  |  | 9
#N/A | NR | Emergency |  |  |  |  | 1 |  |  | 1
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access |  |  |  | 1 | 1 |  |  | 2
#N/A |  | Works | 2 | 3 | 3 | 1 | 1 |  |  | 10
peterborough |  | NR | 2 | 3 | 3 | 2 | 3 |  |  | 13
#N/A | NW | Emergency |  | 1 |  |  |  |  |  | 1
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access
#N/A |  | Works | 3 |  | 2 | 2 |  |  |  | 7
st albans |  | NW | 3 | 1 | 2 | 2 |  |  |  | 8
#N/A | OX | Emergency |  |  |  |  |  | 1 |  | 1
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access |  | 1 |  |  |  |  |  | 1
#N/A |  | Works
sunbury |  | OX |  | 1 |  |  |  | 1 |  | 2
#N/A | PE | Emergency |  | 1 |  |  | 1 |  | 1 | 3
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof |  | 1 |  |  |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access | 1 | 2 |  |  |  |  |  | 3
#N/A |  | Works | 5 | 4 | 1 | 8 | 4 |  |  | 22
peterborough |  | PE | 6 | 8 | 1 | 8 | 5 |  | 1 | 29
#N/A | SG | Emergency |  |  | 1 | 2 |  |  |  | 3
#N/A |  | Specialist Inspection: Asbestos |  |  | 1 |  |  |  |  | 1
#N/A |  | Specialist Inspection: Roof |  |  |  | 1 |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access |  |  | 1 | 1 |  |  |  | 2
#N/A |  | Works | 4 | 1 | 5 | 4 |  |  |  | 14
st albans |  | SG | 4 | 1 | 8 | 8 |  |  |  | 21
#N/A | SL | Emergency |  |  |  |  | 1 |  | 1 | 2
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof |  |  |  |  | 1 |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access
#N/A |  | Works | 3 |  |  | 1 |  |  |  | 4
st albans |  | SL | 3 |  |  | 1 | 2 |  | 1 | 7
#N/A | SW | Emergency |  | 1 |  |  | 2 | 1 |  | 4
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof | 1 |  |  |  |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access
#N/A |  | Works | 3 | 6 |  | 3 | 4 |  |  | 16
sunbury |  | SW | 4 | 7 |  | 3 | 6 | 1 |  | 21
#N/A | TW | Emergency
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof | 1 |  |  |  |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access
#N/A |  | Works | 3 |  | 4 | 2 | 3 |  |  | 12
sunbury |  | TW | 4 |  | 4 | 2 | 3 |  |  | 13
#N/A | W | Emergency | 2 |  | 1 |  |  |  |  | 3
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof
#N/A |  | Specialist Inspection: Trace & Access |  | 1 |  | 1 |  |  |  | 2
#N/A |  | Works | 3 |  | 1 | 1 | 3 |  |  | 8
sunbury |  | W | 5 | 1 | 2 | 2 | 3 |  |  | 13
#N/A | WD | Emergency |  |  |  |  | 1 |  | 1 | 2
#N/A |  | Specialist Inspection: Asbestos
#N/A |  | Specialist Inspection: Roof |  | 1 |  |  |  |  |  | 1
#N/A |  | Specialist Inspection: Trace & Access | 1 |  |  |  |  |  |  | 1
#N/A |  | Works | 2 | 2 | 1 | 4 | 1 |  |  | 10
st albans |  | WD | 3 | 3 | 1 | 4 | 2 |  | 1 | 14
#N/A | TOTAL | Emergency | 3 | 5 | 3 | 3 | 7 | 3 | 4 | 28
#N/A |  | Specialist Inspection: Asbestos |  |  | 1 |  |  |  |  | 1
#N/A |  | Specialist Inspection: Roof | 3 | 2 | 1 | 1 | 2 |  |  | 9
#N/A |  | Specialist Inspection: Trace & Access | 5 | 5 | 3 | 3 | 4 |  |  | 20
#N/A |  | Works | 36 | 35 | 27 | 40 | 26 |  |  | 164
 |  |  | 47 | 47 | 35 | 47 | 39 | 3 | 4 | 222
 |  |  | 2008-06-23 00:00:00 | 2008-06-24 00:00:00 | 2008-06-25 00:00:00 | 2008-06-26 00:00:00 | 2008-06-27 00:00:00 | 2008-06-28 00:00:00 | 2008-06-29 00:00:00
 |  | st albans | 21 | 18 | 21 | 25 | 17 | 1 | 2
 |  | sunbury | 13 | 9 | 6 | 7 | 12 | 2 | 0
 |  | peterborough | 13 | 20 | 8 | 15 | 10 | 0 | 2
 |  | st albans w
 |  | st albans ertf
 |  | sunbury w
 |  | sunbury ertf
 |  | [NAME]
 |  | [NAME]