Spreadsheet: 713826d1610963221-formula-to-sum-column-with-multi-criteria-in-other-columns-test-1-
Sheet: KW 01 Dedicated

 | GastroTiger Dedicated |  |  |  |  |  |  |  |  |  | GEV Inland Dedicated |  |  |  |  |  |  |  |  |  |  |  | GEV MCD Dedicated |  |  |  |  |  |  |  |  |  | GEV Gesamt Dedicated
 |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern |  |  |  |  | KW | Uhrzeit (von) | Uhrzeit (bis) |  | [NAME] | Gespräche | LC | An Extern |  |  |  |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern |  |  |  |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern
 |  | 1 | 0 - 1 | 0 | 0 |  | 0 |  |  |  |  | 1 | 0:00:00 | 1:00:00 |  |  | 0 |  | 0 |  |  |  |  | 1 | 0 - 1 | 0 | 0 |  | 0 |  |  |  |  | 1 | 0 - 1
 |  |  | 1 -2 | 0 | 0 |  | 0 |  |  |  |  |  | 1:00:00 | 2:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 1 -2 | 0 | 0 |  | 0 |  |  |  |  |  | 1 -2
 |  |  | 2 - 3 | 0 | 0 |  | 0 |  |  |  |  |  | 2:00:00 | 3:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 2 - 3 | 0 | 0 |  | 0 |  |  |  |  |  | 2 - 3
 |  |  | 3 - 4 | 0 | 0 |  | 0 |  |  |  |  |  | 3:00:00 | 4:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 3 - 4 | 0 | 0 |  | 0 |  |  |  |  |  | 3 - 4
 |  |  | 4 - 5 | 0 | 0 |  | 0 |  |  |  |  |  | 4:00:00 | 5:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 4 - 5 | 0 | 0 |  | 0 |  |  |  |  |  | 4 - 5
 |  |  | 5 - 6 | 0 | 0 |  | 0 |  |  |  |  |  | 5:00:00 | 6:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 5 - 6 | 0 | 0 |  | 0 |  |  |  |  |  | 5 - 6
 |  |  | 6 - 7 | 0 | 0 |  | 0 |  |  |  |  |  | 6:00:00 | 7:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 6 - 7 | 0 | 0 |  | 0 |  |  |  |  |  | 6 - 7
 |  |  | 7 - 8 | 0 | 0 |  | 0 |  |  |  |  |  | 7:00:00 | 8:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 7 - 8 | 0 | 0 |  | 0 |  |  |  |  |  | 7 - 8
 |  |  | 8 - 8,5 | 0 | 0 |  | 0 |  |  |  |  |  | 8:00:00 | 9:00:00 |  | 19 | 19 |  | 0 |  |  |  |  |  | 8 - 9 | 23 | 22 | 1 | 1 |  |  |  |  |  | 8 - 9
 |  |  | 8,5 - 9 | 9 | 9 |  | 0 |  |  |  |  |  | 9:00:00 | 10:00:00 |  | 26 | 26 |  | 0 |  |  |  |  |  | 9 - 10 | 30 | 28 | 2 | 2 |  |  |  |  |  | 9 - 10
 |  |  | 9 - 10 | 35 | 35 |  | 0 |  |  |  |  |  | 10:00:00 | 11:00:00 |  | 37 | 34 |  | 0 |  |  |  |  |  | 10 - 11 | 29 | 19 | 10 | 7 |  |  |  |  |  | 10 - 11
 |  |  | 10 - 11 | 47 | 47 |  | 0 |  |  |  |  |  | 11:00:00 | 12:00:00 |  | 27 | 27 |  | 0 |  |  |  |  |  | 11 - 12 | 28 | 25 | 3 | 2 |  |  |  |  |  | 11 - 12
 |  |  | 11 - 12 | 48 | 48 |  | 0 |  |  |  |  |  | 12:00:00 | 13:00:00 |  | 24 | 24 |  | 0 |  |  |  |  |  | 12 - 13 | 25 | 25 | 0 | 0 |  |  |  |  |  | 12 - 13
 |  |  | 12 - 13 | 52 | 52 |  | 0 |  |  |  |  |  | 13:00:00 | 14:00:00 |  | 20 | 20 |  | 0 |  |  |  |  |  | 13 - 14 | 22 | 22 | 0 | 0 |  |  |  |  |  | 13 - 14
 |  |  | 13 - 14 | 43 | 43 |  | 0 |  |  |  |  |  | 14:00:00 | 15:00:00 |  | 27 | 27 |  | 0 |  |  |  |  |  | 14 - 15 | 11 | 10 | 1 | 1 |  |  |  |  |  | 14 - 15
 |  |  | 14 - 15 | 47 | 47 |  | 0 |  |  |  |  |  | 15:00:00 | 16:00:00 |  | 31 | 30 |  | 0 |  |  |  |  |  | 15 - 16 | 13 | 11 | 2 | 1 |  |  |  |  |  | 15 - 16
 |  |  | 15 - 16 | 49 | 49 |  | 0 |  |  |  |  |  | 16:00:00 | 17:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 16 - 17 | 0 | 0 | 0 | 0 |  |  |  |  |  | 16 - 17
 |  |  | 16 - 16,5 | 25 | 25 |  | 0 |  |  |  |  |  | 17:00:00 | 18:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 17 - 18 | 0 | 0 |  | 0 |  |  |  |  |  | 17 - 18
 |  |  | 16,5 - 17 | 0 | 0 |  | 0 |  |  |  |  |  | 18:00:00 | 19:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 18 - 19 | 0 | 0 |  | 0 |  |  |  |  |  | 18 - 19
 |  |  | 17 - 18 | 0 | 0 |  | 0 |  |  |  |  |  | 19:00:00 | 20:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 19 - 20 | 0 | 0 |  | 0 |  |  |  |  |  | 19 - 20
 |  |  | 18 - 19 | 0 | 0 |  | 0 |  |  |  |  |  | 20:00:00 | 21:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 20 - 21 | 0 | 0 |  | 0 |  |  |  |  |  | 20 - 21
 |  |  | 19 - 20 | 0 | 0 |  | 0 |  |  |  |  |  | 21:00:00 | 22:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 21 - 22 | 0 | 0 |  | 0 |  |  |  |  |  | 21 - 22
 |  |  | 20 - 21 | 0 | 0 |  | 0 |  |  |  |  |  | 22:00:00 | 23:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 22 - 23 | 0 | 0 |  | 0 |  |  |  |  |  | 22 - 23
 |  |  | 21 - 22 | 0 | 0 |  | 0 |  |  |  |  |  | 23:00:00 | 1 day, 0:00:00 |  | 0 | 0 |  | 0 |  |  |  |  |  | 23 - 24 | 0 | 0 |  | 0 |  |  |  |  |  | 23 - 24
 |  |  | 22 - 23 | 0 | 0 |  | 0
 |  |  | 23 - 24 | 0 | 0 |  | 0
 | Lost Calls Quote |  |  |  | Gesamt |  |  |  |  |  | Lost Calls Quote |  |  |  |  |  | Gesamt |  |  |  |  |  | Lost Calls Quote |  |  |  | Gesamt |  |  |  |  |  | Lost Calls Quote |  |  |  | Gesamt
 | Lost Calls Quote Randzeit |  |  |  | 24 - 8:30 Uhr |  |  |  |  |  | Lost Calls Quote Randzeit |  |  |  |  |  | 24 - 07 Uhr |  |  |  |  |  | Lost Calls Quote Randzeit |  |  |  | 24 - 07 Uhr |  |  |  |  |  | Lost Calls Quote Randzeit |  |  |  | 24 - 07 Uhr
 | Lost Calls Quote Kernzeit |  |  |  | 08:30 - 16:30 Uhr |  |  |  |  |  | Lost Calls Quote Kernzeit |  |  |  |  |  | 08 - 17 Uhr |  |  |  |  |  | Lost Calls Quote Kernzeit |  |  |  | 07 - 16 Uhr |  |  |  |  |  | Lost Calls Quote Kernzeit |  |  |  | 07 - 17 Uhr
 | Lost Calls Quote Randzeit |  |  |  | 16:30 - 24 Uhr |  |  |  |  |  | Lost Calls Quote Randzeit |  |  |  |  |  | 17 - 24 Uhr |  |  |  |  |  | Lost Calls Quote Randzeit |  |  |  | 16 - 24 Uhr |  |  |  |  |  | Lost Calls Quote Randzeit |  |  |  | 16 - 24 Uhr
 | Verarbeitungszeiten |  |  |  |  |  |  |  |  |  | Verarbeitungszeiten |  |  |  |  |  |  |  |  |  |  |  | Verarbeitungszeiten
 | Montag |  | 00:03:08.221000 |  |  |  |  |  |  |  | Montag |  | 00:03:38.375000 |  |  |  |  |  |  |  |  |  | Montag |  | 00:03:39.907000
 | Dienstag |  | 00:03:42.469000 |  |  |  |  |  |  |  | Dienstag |  | 00:03:24.579000 |  |  |  |  |  |  |  |  |  | Dienstag |  | 00:02:25.478000
 | Mittwoch |  | 00:03:19.356000 |  |  |  |  |  |  |  | Mittwoch |  | 00:03:48.455000 |  |  |  |  |  |  |  |  |  | Mittwoch |  | 00:02:49.125000
 | Donnerstag |  | 00:03:17.250000 |  |  |  |  |  |  |  | Donnerstag |  | 00:00:00 |  |  |  |  |  |  |  |  |  | Donnerstag |  | 00:03:55.167000
 | Freitag |  | 00:00:00 |  |  |  |  |  |  |  | Freitag |  | 00:00:00 |  |  |  |  |  |  |  |  |  | Freitag |  | 00:00:00
 | Gesamt Ø |  |  |  |  |  |  |  |  |  | Gesamt Ø |  |  |  |  |  |  |  |  |  |  |  | Gesamt Ø