Spreadsheet: 713824d1610962399-formula-to-sum-column-with-multi-criteria-in-other-columns-test
Sheet: KW 01 Überlauf

 | [NAME] |  |  |  |  |  |  |  |  |  | GEV Inland Überlauf |  |  |  |  |  |  |  |  |  | GEV MCD Überlauf |  |  |  |  |  |  |  |  |  | GEV Gesamt Überlauf
 |  | KW | Uhrzeit | [NAME] | Gespräche | LC | An Extern |  |  |  |  | KW | Uhrzeit | [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 | 1 | 1 |  | 0 |  |  |  |  | 1 | 0 - 1 | 0 | 0 |  | 0 |  |  |  |  | 1 | 0 - 1 | 0 | 0 |  | 0 |  |  |  |  | 1 | 0 - 1
 |  |  | 1 -2 | 0 | 0 |  | 0 |  |  |  |  |  | 1 -2 | 0 | 0 |  | 0 |  |  |  |  |  | 1 -2 | 0 | 0 |  | 0 |  |  |  |  |  | 1 -2
 |  |  | 2 - 3 | 1 | 1 |  | 0 |  |  |  |  |  | 2 - 3 | 0 | 0 |  | 0 |  |  |  |  |  | 2 - 3 | 0 | 0 |  | 0 |  |  |  |  |  | 2 - 3
 |  |  | 3 - 4 | 0 | 0 |  | 0 |  |  |  |  |  | 3 - 4 | 1 | 1 |  | 0 |  |  |  |  |  | 3 - 4 | 1 | 1 |  | 0 |  |  |  |  |  | 3 - 4
 |  |  | 4 - 5 | 0 | 0 |  | 0 |  |  |  |  |  | 4 - 5 | 0 | 0 |  | 0 |  |  |  |  |  | 4 - 5 | 1 | 1 |  | 0 |  |  |  |  |  | 4 - 5
 |  |  | 5 - 6 | 0 | 0 |  | 0 |  |  |  |  |  | 5 - 6 | 0 | 0 |  | 0 |  |  |  |  |  | 5 - 6 | 0 | 0 |  | 0 |  |  |  |  |  | 5 - 6
 |  |  | 6 - 7 | 0 | 0 |  | 0 |  |  |  |  |  | 6 - 7 | 0 | 0 |  | 0 |  |  |  |  |  | 6 - 7 | 0 | 0 |  | 0 |  |  |  |  |  | 6 - 7
 |  |  | 7 - 8 | 1 | 1 |  | 0 |  |  |  |  |  | 7 - 8 | 0 | 0 |  | 0 |  |  |  |  |  | 7 - 8 | 7 | 3 |  | 0 |  |  |  |  |  | 7 - 8
 |  |  | 8 - 8,5 | 9 | 9 |  | 0 |  |  |  |  |  | 8 - 9 | 2 | 0 |  | 1 |  |  |  |  |  | 8 - 9 | 0 | 0 |  | 0 |  |  |  |  |  | 8 - 9
 |  |  | 8,5 - 9 | 2 | 1 |  | 1 |  |  |  |  |  | 9 - 10 | 5 | 1 |  | 4 |  |  |  |  |  | 9 - 10 | 2 | 1 |  | 0 |  |  |  |  |  | 9 - 10
 |  |  | 9 - 10 | 12 | 10 |  | 1 |  |  |  |  |  | 10 - 11 | 13 | 4 |  | 10 |  |  |  |  |  | 10 - 11 | 1 | 1 |  | 0 |  |  |  |  |  | 10 - 11
 |  |  | 10 - 11 | 24 | 20 |  | 4 |  |  |  |  |  | 11 - 12 | 6 | 2 |  | 3 |  |  |  |  |  | 11 - 12 | 3 | 3 |  | 0 |  |  |  |  |  | 11 - 12
 |  |  | 11 - 12 | 19 | 17 |  | 1 |  |  |  |  |  | 12 - 13 | 2 | 0 |  | 2 |  |  |  |  |  | 12 - 13 | 1 | 1 |  | 0 |  |  |  |  |  | 12 - 13
 |  |  | 12 - 13 | 6 | 5 |  | 0 |  |  |  |  |  | 13 - 14 | 3 | 1 |  | 2 |  |  |  |  |  | 13 - 14 | 1 | 1 |  | 0 |  |  |  |  |  | 13 - 14
 |  |  | 13 - 14 | 12 | 10 |  | 1 |  |  |  |  |  | 14 - 15 | 5 | 1 |  | 0 |  |  |  |  |  | 14 - 15 | 1 | 1 |  | 0 |  |  |  |  |  | 14 - 15
 |  |  | 14 - 15 | 10 | 9 |  | 0 |  |  |  |  |  | 15 - 16 | 1 | 1 |  | 4 |  |  |  |  |  | 15 - 16 | 0 | 0 |  | 0 |  |  |  |  |  | 15 - 16
 |  |  | 15 - 16 | 7 | 7 |  | 0 |  |  |  |  |  | 16 - 17 | 0 | 0 |  | 0 |  |  |  |  |  | 16 - 17 | 5 | 5 |  | 0 |  |  |  |  |  | 16 - 17
 |  |  | 16 - 16,5 | 5 | 3 |  | 0 |  |  |  |  |  | 17 - 18 | 0 | 0 |  | 0 |  |  |  |  |  | 17 - 18 | 2 | 2 |  | 0 |  |  |  |  |  | 17 - 18
 |  |  | 16,5 - 17 | 16 | 16 |  | 0 |  |  |  |  |  | 18 - 19 | 0 | 0 |  | 0 |  |  |  |  |  | 18 - 19 | 3 | 3 |  | 0 |  |  |  |  |  | 18 - 19
 |  |  | 17 - 18 | 16 | 15 |  | 0 |  |  |  |  |  | 19 - 20 | 0 | 0 |  | 0 |  |  |  |  |  | 19 - 20 | 1 | 1 |  | 0 |  |  |  |  |  | 19 - 20
 |  |  | 18 - 19 | 8 | 7 |  | 0 |  |  |  |  |  | 20 - 21 | 0 | 0 |  | 0 |  |  |  |  |  | 20 - 21 | 0 | 0 |  | 0 |  |  |  |  |  | 20 - 21
 |  |  | 19 - 20 | 3 | 2 |  | 0 |  |  |  |  |  | 21 - 22 | 0 | 0 |  | 0 |  |  |  |  |  | 21 - 22 | 0 | 0 |  | 0 |  |  |  |  |  | 21 - 22
 |  |  | 20 - 21 | 6 | 5 |  | 0 |  |  |  |  |  | 22 - 23 | 0 | 0 |  | 0 |  |  |  |  |  | 22 - 23 | 0 | 0 |  | 0 |  |  |  |  |  | 22 - 23
 |  |  | 21 - 22 | 0 | 0 |  | 0 |  |  |  |  |  | 23 - 24 | 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
 | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
 | Montag |  | 00:04:51.571000 |  |  |  |  |  |  |  | Monatg |  | 00:01:29.667000 |  |  |  |  |  |  |  | Monatg |  | 00:01:52
 | Dienstag |  | 00:04:29.667000 |  |  |  |  |  |  |  | Dienstag |  | 00:00:00 |  |  |  |  |  |  |  | Dienstag |  | 00:04:11
 | Mittwoch |  | 00:02:09 |  |  |  |  |  |  |  | Mittwoch |  | 00:00:00 |  |  |  |  |  |  |  | Mittwoch |  | 00:02:08.667000
 | Donnerstag |  | 00:00:00 |  |  |  |  |  |  |  | Donnerstag |  | 00:00:00 |  |  |  |  |  |  |  | Donnerstag |  | 00:00:00
 | Freitag |  | 00:05:42.250000 |  |  |  |  |  |  |  | Freitag |  | 00:00:00 |  |  |  |  |  |  |  | Freitag |  | 00:00:00
 | Gesamt Ø |  |  |  |  |  |  |  |  |  | Gesamt Ø |  |  |  |  |  |  |  |  |  | Gesamt Ø
 | Verarbeitungszeit Randzeit |  |  |  |  |  |  |  |  |  | Verarbeitungszeit Randzeit |  |  |  |  |  |  |  |  |  | Verarbeitungszeit Randzeit
 | Montag |  | 00:05:09.222000 |  |  |  |  |  |  |  | Monatg |  | 00:00:00 |  |  |  |  |  |  |  | Monatg |  | 00:07:20
 | Dienstag |  | 00:05:42 |  |  |  |  |  |  |  | Dienstag |  | 00:00:00 |  |  |  |  |  |  |  | Dienstag |  | 00:07:17
 | Mittwoch |  | 00:12:52 |  |  |  |  |  |  |  | Mittwoch |  | 00:00:00 |  |  |  |  |  |  |  | Mittwoch |  | 00:04:51
 | Donnerstag |  | 00:00:00 |  |  |  |  |  |  |  | Donnerstag |  | 00:00:00 |  |  |  |  |  |  |  | Donnerstag |  | 00:00:00
 | Freitag |  | 00:08:53 |  |  |  |  |  |  |  | Freitag |  | 00:00:00 |  |  |  |  |  |  |  | Freitag |  | 00:00:00
 | Samstag |  | 00:08:01.750000 |  |  |  |  |  |  |  | Samstag |  | 00:00:00 |  |  |  |  |  |  |  | Samstag |  | 00:07:07.250000
 | Sonntag |  | 00:03:58 |  |  |  |  |  |  |  | Sonntag |  | 00:00:00 |  |  |  |  |  |  |  | Sonntag |  | 00:00:00
 | Gesamt Ø |  |  |  |  |  |  |  |  |  | Gesamt Ø |  |  |  |  |  |  |  |  |  | Gesamt Ø