Spreadsheet: 238707d1369683634-help-me-pivot-tables-sumif-vlook-up-excel-questionsss
Sheet: Aspect calls

Call date | Campaign | Call length (minutes)
01.01.2011 | Plumbing | 2.9
01.01.2011 | Plumbing | 1
01.01.2011 | Plumbing | 2.4
01.01.2011 | Plumbing | 2
01.01.2011 | Plumbing | 2
02.01.2011 | Plumbing | 1.1
02.01.2011 | Plumbing | 1
02.01.2011 | Plumbing Emergency | 0.01
02.01.2011 | Plumbing Emergency | 2
02.01.2011 | Plumbing Emergency | 2
02.01.2011 | Plumbing Emergency | 1
02.01.2011 | Plumbing | 3
02.01.2011 | Plumbing | 1.8
03.01.2011 | Plumbing | 4
03.01.2011 | Plumbing | 1
03.01.2011 | Extensions | 2
03.01.2011 | Extensions | 1.5
03.01.2011 | Extensions | 2.6
04.01.2011 | Extensions | 4.2
04.01.2011 | Extensions | 1.2
04.01.2011 | Extensions | 1.5
05.01.2011 | Extensions | 8.5
01.01.2011 | Electrician | 9
01.01.2011 | Electrician | 6.1
01.01.2011 | Electrician | 0.5
01.01.2011 | Electrician | 0.5
01.01.2011 | Electrician | 0.75
02.01.2011 | Electrician | 1.8
02.01.2011 | Electrician Emergency | 2.7
02.01.2011 | Electrician | 7
02.01.2011 | Electrician | 6.1
02.01.2011 | Electrician | 0.8
02.01.2011 | Electrician Emergency | 3.5
02.01.2011 | Electrician | 6.1
02.01.2011 | Electrician | 0.5
03.01.2011 | Electrician | 0.5
03.01.2011 | Electrician | 0.75
03.01.2011 | Electrician | 1.8
03.01.2011 | Electrician | 2.7
03.01.2011 | Electrician | 0.8
04.01.2011 | Electrician | 3.5
04.01.2011 | Electrician Emergency | 2
04.01.2011 | Electrician | 1.8
05.01.2011 | Electrician | 2.7
05.01.2011 | Electrician | 0.8
05.01.2011 | Electrician Emergency | 1.5
05.01.2011 | Electrician | 0.5
05.01.2011 | Electrician | 0.5
05.01.2011 | Electrician | 0.75
05.01.2011 | Electrician | 1.8
05.01.2011 | Electrician | 2.7
05.01.2011 | Electrician | 0.8
05.01.2011 | Electrician | 3.5
05.01.2011 | Electrician | 2
05.01.2011 | Electrician | 1.8
06.01.2011 | Electrician | 2.7
06.01.2011 | Electrician | 0.8
06.01.2011 | Electrician Emergency | 0.4
06.01.2011 | Electrician | 3.5
06.01.2011 | Electrician | 2
06.01.2011 | Electrician | 1.8
06.01.2011 | Electrician | 2.7
06.01.2011 | Electrician | 0.8
01.01.2011 | [NAME] | 0.8
01.01.2011 | Handyman | 3.5
01.01.2011 | Handyman | 2
01.01.2011 | Handyman | 1.8
01.01.2011 | Handyman | 2.7
02.01.2011 | Handyman | 0.8
02.01.2011 | Handyman | 2.7
02.01.2011 | Handyman | 0.8
02.01.2011 | Handyman | 2.7
02.01.2011 | Handyman | 0.8
02.01.2011 | [NAME] | 1.9
02.01.2011 | Handyman | 1.8
02.01.2011 | Handyman | 2.7
04.01.2011 | Handyman | 0.8
04.01.2011 | Handyman | 0.8
01.01.2011 | Locksmith | 3.5
01.01.2011 | Locksmith | 2
01.01.2011 | Locksmith | 1.8
01.01.2011 | Locksmith | 2.7
01.01.2011 | Locksmith | 0.8
02.01.2011 | Locksmith | 2.7
02.01.2011 | Locksmith Emergency | 1.95
02.01.2011 | Locksmith | 0.8
02.01.2011 | Locksmith | 0.8
02.01.2011 | Locksmith | 3.5
02.01.2011 | Locksmith | 2
02.01.2011 | Locksmith | 1.8
02.01.2011 | Locksmith | 2.7
03.01.2011 | Locksmith | 0.8
03.01.2011 | Locksmith | 2.7
03.01.2011 | Locksmith | 1.95
03.01.2011 | Locksmith | 0.8
03.01.2011 | Locksmith Emergency | 0.5
04.01.2011 | Locksmith | 0.8
04.01.2011 | Locksmith | 2.7
01.01.2011 | Gas Repair | 1.95
01.01.2011 | Gas Repair | 0.4
01.01.2011 | Gas Repair Emergency | 1.95
01.01.2011 | Gas Repair | 2
01.01.2011 | Gas Repair | 3.5
02.01.2011 | Gas Repair Emergency | 2
02.01.2011 | Gas Repair | 1.8
02.01.2011 | Gas Repair Emergency | 2.7
02.01.2011 | Gas Repair | 0.8
02.01.2011 | Gas Repair | 2.7
02.01.2011 | Gas Repair | 1.95
02.01.2011 | Gas Repair | 0.8
02.01.2011 | Gas Repair | 0.5
03.01.2011 | Gas Repair Emergency | 0.8
03.01.2011 | Gas Repair | 2.7
03.01.2011 | Gas Repair | 2
03.01.2011 | Gas Repair | 1.8
03.01.2011 | Gas Repair | 2.7
02.01.2011 | Gas Repair | 5
04.01.2011 | Gas Repair | 2.7
04.01.2011 | Gas Repair Emergency | 1.95
04.01.2011 | Gas Repair | 0.8
04.01.2011 | Gas Repair | 0.5
04.01.2011 | Gas Repair | 0.8
04.01.2011 | Gas Repair Emergency | 2.7
05.01.2011 | Gas Repair | 2
05.01.2011 | Gas Repair | 1.8
05.01.2011 | Gas Repair Emergency | 2.7
05.01.2011 | Gas Repair | 5
05.01.2011 | Gas Repair | 2.7
05.01.2011 | Gas Repair | 1.95
05.01.2011 | Gas Repair | 0.8
05.01.2011 | Gas Repair | 0.5
06.01.2011 | Gas Repair | 2
06.01.2011 | Gas Repair Emergency | 0.5