Spreadsheet: 802288d1666772924-filter-inside-countif-excelfile-filter
Sheet: Blad1

 |  |  |  | Can I make this part dynamic with filter or something else? |  |  |  | week
 |  |  |  |  |  |  |  | date | 2022-01-03 00:00:00 | 2022-01-10 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | 2022-01-31 00:00:00 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | 2022-02-21 00:00:00 | 2022-02-28 00:00:00 | 2022-03-07 00:00:00 | 2022-03-14 00:00:00 | 2022-03-21 00:00:00 | 2022-03-28 00:00:00 | 2022-04-04 00:00:00 | 2022-04-11 00:00:00 | 2022-04-18 00:00:00 | 2022-04-25 00:00:00 | 2022-05-02 00:00:00 | 2022-05-09 00:00:00 | 2022-05-16 00:00:00 | 2022-05-23 00:00:00 | 2022-05-30 00:00:00 | 2022-06-06 00:00:00 | 2022-06-13 00:00:00 | 2022-06-20 00:00:00 | 2022-06-27 00:00:00 | 2022-07-04 00:00:00 | 2022-07-11 00:00:00 | 2022-07-18 00:00:00 | 2022-07-25 00:00:00 | 2022-08-01 00:00:00 | 2022-08-08 00:00:00 | 2022-08-15 00:00:00 | 2022-08-22 00:00:00 | 2022-08-29 00:00:00 | 2022-09-05 00:00:00 | 2022-09-12 00:00:00 | 2022-09-19 00:00:00 | 2022-09-26 00:00:00 | 2022-10-03 00:00:00 | 2022-10-10 00:00:00 | 2022-10-17 00:00:00 | 2022-10-24 00:00:00 | 2022-10-31 00:00:00 | 2022-11-07 00:00:00 | 2022-11-14 00:00:00 | 2022-11-21 00:00:00 | 2022-11-28 00:00:00 | 2022-12-05 00:00:00 | 2022-12-12 00:00:00 | 2022-12-19 00:00:00 | 2022-12-26 00:00:00
Transport | model | checkups | last checkup | #checkups left this year | #Gas checkups due | Test2 | #Gas checkups due2 | . | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
#1 | Ford | Oil,Gas,Battery | 2022-04-10 00:00:00 |  |  |  |  |  | oil |  |  | Gas |  |  |  | Gas |  | Battery |  | Gas | Oil |  |  | Gas |  |  |  | Gas |  |  |  |  | Oil |  |  | Gas |  |  |  | Gas |  |  |  | Gas | Oil |  |  | Gas |  | Battery |  | Gas |  |  |  | Gas | Oil |  |  | Gas
#2 | Ford | Oil,Gas, Battery | 2022-03-25 00:00:00 |  |  |  |  |  | Oil,Gas,Battery |  |  |  |  | Oil,Gas |  |  |  |  | Oil,Gas |  |  |  |  | Oil,Gas,Battery |  |  |  |  | Oil,Gas |  |  |  | Battery |  |  |  |  |  | Oil,Gas |  |  | Battery |  | Oil,Gas |  |  |  |  | Oil,Gas |  |  | Battery |  | Oil,Gas |  |  |  |  | Oil,Gas
#3 | Tesla | Battery | 2022-05-01 00:00:00 |  |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery |  |  |  |  | Battery
#4 | Bike | Chain | 2022-03-19 00:00:00 |  |  |  |  |  | Chain |  |  |  |  |  |  |  |  |  |  |  | Chain |  |  |  |  |  |  |  |  |  |  |  | Chain |  |  |  |  |  |  |  |  |  |  |  | Chain |  |  |  |  |  |  |  |  |  |  |  | Chain
#5 | Shoes | Cleaning | 2022-07-08 00:00:00 |  |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning |  |  |  |  | Cleaning
#6 | Boat | Sail | 2022-02-05 00:00:00 |  |  |  |  |  | Sail |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sail |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sail |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sail
…
… |  |  |  |  |  | Checkup done
… |  |  |  |  |  | Checkup missed!
#102
 |  |  |  | #checkups left this year (filter)
 |  |  | 4
 |  |  | 4
 |  |  | 2
 |  |  | 1
 |  |  | 2
 |  |  | 1
 |  |  |  | #Gas checkups due (wildcard doesnt work in filter?)