Spreadsheet: 713800d1610948080-sumproduct-with-2-criteria-first-last-cell-in-a-row-and-return-another-cell-testlog
Sheet: Progressplan

 |  |  |  | 2019 |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  | Sep | Okt | Nov | Dez | Jan | Feb | MÄR |  |  |  |  |  |  | APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OKT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEZ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MÄR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JUL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OKT | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug
 |  |  |  |  |  |  |  |  |  | Wochen 13 |  |  |  |  | KW 14 |  |  |  |  | KW 15 |  |  |  |  | KW 16 |  |  |  |  | KW 17 |  |  |  |  | KW 18 |  |  |  |  | KW 19 |  |  |  |  | KW 20 |  |  |  |  | KW 21 |  |  |  |  | KW 22 |  |  |  |  | KW 23 |  |  |  |  | KW 24 |  |  |  |  | KW 25 |  |  |  |  | KW 26 |  |  |  |  | KW 27 |  |  |  |  | KW 28 |  |  |  |  | KW 29 |  |  |  |  | KW 30 |  |  |  |  | KW 31 |  |  |  |  | KW 32 |  |  |  |  | KW 33 |  |  |  |  | KW 34 |  |  |  |  | KW 35 |  |  |  |  | KW 36 |  |  |  |  | KW 37 |  |  |  |  | KW 38 |  |  |  |  | KW 39 |  |  |  |  | KW 40 |  |  |  |  | KW 41 |  |  |  |  | KW 42 |  |  |  |  | KW 43 |  |  |  |  | KW 44 |  |  |  |  | KW 45 |  |  |  |  | KW 46 |  |  |  |  | KW 47 |  |  |  |  | KW 48 |  |  |  |  | KW 49 |  |  |  |  | KW 50 |  |  |  |  | KW 51 |  |  |  |  | KW 52 |  |  |  |  | KW 53/0 |  |  |  |  | KW 1 |  |  |  |  | KW 2 |  |  |  |  | KW 3 |  |  |  |  | KW 4 |  |  |  |  | KW 5 |  |  |  |  | KW 6 |  |  |  |  | KW 7 |  |  |  |  | KW 8 |  |  |  |  | KW 9 |  |  |  |  | KW 10 |  |  |  |  | KW 11 |  |  |  |  | KW 12 |  |  |  |  | KW 13 |  |  |  |  | KW 14 |  |  |  |  | KW 15 |  |  |  |  | KW 16 |  |  |  |  | KW 17 |  |  |  |  | KW 18 |  |  |  |  | KW 19 |  |  |  |  | KW 20 |  |  |  |  | KW 21 |  |  |  |  | KW 22 |  |  |  |  | KW 23 |  |  |  |  | KW 24 |  |  |  |  | KW 25 |  |  |  |  | KW 26 |  |  |  |  | KW 27 |  |  |  |  | KW 28 |  |  |  |  | KW 29 |  |  |  |  | KW 30 |  |  |  |  | KW 31 |  |  |  |  | KW 32 |  |  |  |  | KW 33 |  |  |  |  | KW 34 |  |  |  |  | KW 35 |  |  |  |  | KW 36 |  |  |  |  | KW 37 |  |  |  |  | KW 38 |  |  |  |  | KW 39
 |  |  |  |  |  |  |  |  |  | 2020-03-23 00:00:00 | 2020-03-24 00:00:00 | 2020-03-25 00:00:00 | 2020-03-26 00:00:00 | 2020-03-27 00:00:00 | 2020-03-30 00:00:00 | 2020-03-31 00:00:00 | 2020-04-01 00:00:00 | 2020-04-02 00:00:00 | 2020-04-03 00:00:00 | 2020-04-06 00:00:00 | 2020-04-07 00:00:00 | 2020-04-08 00:00:00 | 2020-04-09 00:00:00 | 2020-04-10 00:00:00 | 2020-04-13 00:00:00 | 2020-04-14 00:00:00 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2020-04-17 00:00:00 | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2020-07-20 00:00:00 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2020-07-27 00:00:00 | 2020-07-28 00:00:00 | 2020-07-29 00:00:00 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-03 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-08-10 00:00:00 | 2020-08-11 00:00:00 | 2020-08-12 00:00:00 | 2020-08-13 00:00:00 | 2020-08-14 00:00:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00 | 2020-09-09 00:00:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00 | 2020-09-14 00:00:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | 2020-09-17 00:00:00 | 2020-09-18 00:00:00 | 2020-09-21 00:00:00 | 2020-09-22 00:00:00 | 2020-09-23 00:00:00 | 2020-09-24 00:00:00 | 2020-09-25 00:00:00 | 2020-09-28 00:00:00 | 2020-09-29 00:00:00 | 2020-09-30 00:00:00 | 2020-10-01 00:00:00 | 2020-10-02 00:00:00 | 2020-10-05 00:00:00 | 2020-10-06 00:00:00 | 2020-10-07 00:00:00 | 2020-10-08 00:00:00 | 2020-10-09 00:00:00 | 2020-10-12 00:00:00 | 2020-10-13 00:00:00 | 2020-10-14 00:00:00 | 2020-10-15 00:00:00 | 2020-10-16 00:00:00 | 2020-10-19 00:00:00 | 2020-10-20 00:00:00 | 2020-10-21 00:00:00 | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00 | 2020-11-02 00:00:00 | 2020-11-03 00:00:00 | 2020-11-04 00:00:00 | 2020-11-05 00:00:00 | 2020-11-06 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-23 00:00:00 | 2020-11-24 00:00:00 | 2020-11-25 00:00:00 | 2020-11-26 00:00:00 | 2020-11-27 00:00:00 | 2020-11-30 00:00:00 | 2020-12-01 00:00:00 | 2020-12-02 00:00:00 | 2020-12-03 00:00:00 | 2020-12-04 00:00:00 | 2020-12-07 00:00:00 | 2020-12-08 00:00:00 | 2020-12-09 00:00:00 | 2020-12-10 00:00:00 | 2020-12-11 00:00:00 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00 | 2020-12-18 00:00:00 | 2020-12-21 00:00:00 | 2020-12-22 00:00:00 | 2020-12-23 00:00:00 | 2020-12-24 00:00:00 | 2020-12-25 00:00:00 | 2020-12-28 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-01 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-18 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-01-25 00:00:00 | 2021-01-26 00:00:00 | 2021-01-27 00:00:00 | 2021-01-28 00:00:00 | 2021-01-29 00:00:00 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 | 2021-04-07 00:00:00 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00 | 2021-04-12 00:00:00 | 2021-04-13 00:00:00 | 2021-04-14 00:00:00 | 2021-04-15 00:00:00 | 2021-04-16 00:00:00 | 2021-04-19 00:00:00 | 2021-04-20 00:00:00 | 2021-04-21 00:00:00 | 2021-04-22 00:00:00 | 2021-04-23 00:00:00 | 2021-04-26 00:00:00 | 2021-04-27 00:00:00 | 2021-04-28 00:00:00 | 2021-04-29 00:00:00 | 2021-04-30 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2021-05-31 00:00:00 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-09 00:00:00 | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-16 00:00:00 | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-19 00:00:00 | 2021-08-20 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 | 2021-09-08 00:00:00 | 2021-09-09 00:00:00 | 2021-09-10 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-16 00:00:00 | 2021-09-17 00:00:00 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00 | 2021-10-01 00:00:00
 | [NAME] nach Typen -
 | Pflug
 | Querungen
 | [NAME]
 | Pflaster
 | Asphalt
 | Rakete
 | Querungen
 | Ausführung
 | Feinplanung |  | 1
 | Genehmigungen |  | 1
 | [NAME]
True | VRS-007
True | VRS-008
False | VRS-009
False | VRS-010
False | [NAME]
False | VRS-012
False | VRS-013
False | VRS-014
False | VRS-015
False | VRS-016
False | VRS-017
False | VRS-018
False | VRS-019
False | VRS-020
False | VRS-021
False | VRS-022
False | VRS-023
False | VRS-024
False | VRS-025
False | VRS-026
False | VRS-027
False | VRS-028
False | VRS-029
False | VRS-030
 | Hausanschlüsse: |  | 0
 | Montage(FCP+DP) |  | 0
 | Kundenaktivierung |  | 0
 | Dokumentation |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5