Spreadsheet: 888833d1739435493-using-if-formula-for-each-instance-in-sumproduct-table_test
Sheet: Sharepoint

Project number | Order sum | Start | Finish | Department | Order date | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | Status
1 | 10000 | 2024-12-13 00:00:00 | 2024-12-31 00:00:00 | A | 2024-12-13 00:00:00 |  |  |  |  |  |  | Ordre
10 | 9600000 | 2024-03-04 00:00:00 | 2026-07-31 00:00:00 | D | 2024-02-05 00:00:00 |  |  |  |  |  |  | Ordre
11 | 1319729 | 2024-03-11 00:00:00 | 2024-05-08 00:00:00 | D | 2024-02-27 00:00:00 |  |  |  |  |  |  | Ordre
12 | 0 | 2024-12-09 00:00:00 | 2024-12-13 00:00:00 | B | 2024-11-29 00:00:00 |  |  |  |  |  |  | Ordre
13 | 4960842 | 2024-11-05 00:00:00 | 2027-11-01 00:00:00 | B | 2024-11-26 00:00:00 |  |  |  |  |  |  | Ordre
14 | 0 | 2024-11-04 00:00:00 | 2024-11-08 00:00:00 | B | 2024-10-25 00:00:00 |  |  |  |  |  |  | Ordre
15 | 0 | 2024-10-24 00:00:00 | 2024-10-28 00:00:00 | B | 2024-10-23 00:00:00 |  |  |  |  |  |  | Ordre
16 | 95000 | 2024-11-25 00:00:00 | 2024-12-06 00:00:00 | B | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
17 | 36000 | 2025-01-06 00:00:00 | 2025-01-10 00:00:00 | B | 2024-10-22 00:00:00 |  |  |  |  |  |  | Ordre
18 | 59800 | 2024-11-11 00:00:00 | 2024-11-15 00:00:00 | B | 2024-10-21 00:00:00 |  |  |  |  |  |  | Ordre
19 | 570000 | 2024-10-28 00:00:00 | 2025-12-22 00:00:00 | B | 2024-10-22 00:00:00 |  |  |  |  |  |  | Ordre
2 | 1 | 2024-12-06 00:00:00 | 2024-12-31 00:00:00 | A | 2024-12-06 00:00:00 |  |  |  |  |  |  | Ordre
20 | 144529 | 2024-10-21 00:00:00 | 2024-11-01 00:00:00 | B | 2024-10-03 00:00:00 |  |  |  |  |  |  | Ordre
21 | 66000 | 2024-09-16 00:00:00 | 2024-09-20 00:00:00 | B | 2024-08-27 00:00:00 |  |  |  |  |  |  | Ordre
22 | 92000 | 2024-12-05 00:00:00 | 2025-12-10 00:00:00 | B | 2024-11-22 00:00:00 |  |  |  |  |  |  | Ordre
23 | 3370400 | 2024-08-26 00:00:00 | 2025-03-28 00:00:00 | B | 2024-07-11 00:00:00 |  |  |  |  |  |  | Ordre
24 | 854050 | 2024-09-16 00:00:00 | 2025-02-25 00:00:00 | B | 2024-09-04 00:00:00 |  |  |  |  |  |  | Ordre
25 | 114000 | 2025-01-13 00:00:00 | 2025-01-21 00:00:00 | B | 2024-10-02 00:00:00 |  |  |  |  |  |  | Ordre
26 | 450450 | 2024-09-19 00:00:00 | 2024-12-20 00:00:00 | B | 2024-09-05 00:00:00 |  |  |  |  |  |  | Ordre
27 | 52000 | 2024-11-11 00:00:00 | 2024-11-15 00:00:00 | B | 2024-10-14 00:00:00 |  |  |  |  |  |  | Ordre
28 | 1386100 | 2024-06-10 00:00:00 | 2025-06-19 00:00:00 | B | 2024-05-23 00:00:00 |  |  |  |  |  |  | Ordre
29 | 399812 | 2024-08-12 00:00:00 | 2024-10-11 00:00:00 | B | 2024-06-13 00:00:00 |  |  |  |  |  |  | Ordre
3 | 45000 | 2024-12-06 00:00:00 | 2024-12-31 00:00:00 | A | 2024-12-06 00:00:00 |  |  |  |  |  |  | Ordre
30 | 198000 | 2024-08-26 00:00:00 | 2024-09-20 00:00:00 | B | 2024-08-08 00:00:00 |  |  |  |  |  |  | Ordre
31 | 90000 | 2024-08-19 00:00:00 | 2024-08-30 00:00:00 | B | 2024-05-06 00:00:00 |  |  |  |  |  |  | Ordre
32 | 150000 | 2024-08-26 00:00:00 | 2024-09-22 00:00:00 | B | 2024-08-16 00:00:00 |  |  |  |  |  |  | Ordre
33 | 197000 | 2024-08-12 00:00:00 | 2024-09-13 00:00:00 | B | 2024-07-02 00:00:00 |  |  |  |  |  |  | Ordre
34 | 5350000 | 2025-02-03 00:00:00 | 2027-05-31 00:00:00 | B | 2024-06-14 00:00:00 |  |  |  |  |  |  | Ordre
35 | 3550000 | 2024-08-19 00:00:00 | 2026-12-14 00:00:00 | B | 2024-06-14 00:00:00 |  |  |  |  |  |  | Ordre
36 | 5525000 | 2024-03-01 00:00:00 | 2025-07-01 00:00:00 | B | 2024-01-03 00:00:00 |  |  |  |  |  |  | Ordre
37 | 34070969 | 2024-11-18 00:00:00 | 2027-10-04 00:00:00 | D | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
38 | 946575 | 2024-08-12 00:00:00 | 2025-11-20 00:00:00 | B | 2024-07-02 00:00:00 |  |  |  |  |  |  | Ordre
39 | 1613060 | 2024-02-05 00:00:00 | 2025-08-06 00:00:00 | B | 2024-01-09 00:00:00 |  |  |  |  |  |  | Ordre
4 | 22000 | 2024-11-29 00:00:00 | 2024-12-16 00:00:00 | A | 2024-11-29 00:00:00 |  |  |  |  |  |  | Ordre
40 | 448556 | 2024-05-01 00:00:00 | 2024-05-30 00:00:00 | B | 2024-03-14 00:00:00 |  |  |  |  |  |  | Ordre
41 | 1975000 | 2024-09-23 00:00:00 | 2025-02-24 00:00:00 | B | 2024-10-16 00:00:00 |  |  |  |  |  |  | Ordre
42 | 182015 | 2024-08-12 00:00:00 | 2024-08-30 00:00:00 | B | 2024-08-08 00:00:00 |  |  |  |  |  |  | Ordre
43 | 2653129 | 2024-06-17 00:00:00 | 2024-08-16 00:00:00 | B | 2024-06-06 00:00:00 |  |  |  |  |  |  | Ordre
44 | 50000 | 2024-06-03 00:00:00 | 2024-08-31 00:00:00 | C | 2024-06-10 00:00:00 |  |  |  |  |  |  | Ordre
45 | 787000 | 2024-11-27 00:00:00 | 2025-01-20 00:00:00 | B | 2024-12-03 00:00:00 |  |  |  |  |  |  | Ordre
46 | 87500 | 2024-10-21 00:00:00 | 2024-11-01 00:00:00 | B | 2024-10-09 00:00:00 |  |  |  |  |  |  | Ordre
47 | 139270 | 2024-11-04 00:00:00 | 2024-11-15 00:00:00 | B | 2024-06-04 00:00:00 |  |  |  |  |  |  | Ordre
48 | 947077 | 2024-07-15 00:00:00 | 2024-10-18 00:00:00 | B | 2024-05-21 00:00:00 |  |  |  |  |  |  | Ordre
49 | 69000 | 2024-12-09 00:00:00 | 2024-12-11 00:00:00 | C | 2024-11-27 00:00:00 |  |  |  |  |  |  | Ordre
5 | 6000 | 2024-11-20 00:00:00 | 2024-11-30 00:00:00 | A | 2024-11-20 00:00:00 |  |  |  |  |  |  | Ordre
50 | 228000 | 2024-11-25 00:00:00 | 2024-12-31 00:00:00 | C | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
51 | 3494210 | 2024-11-11 00:00:00 | 2025-03-31 00:00:00 | C | 2024-10-25 00:00:00 |  |  |  |  |  |  | Ordre
52 | 189000 | 2025-01-03 00:00:00 | 2025-01-06 00:00:00 | C | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
53 | 6197350 | 2024-04-08 00:00:00 | 2025-10-30 00:00:00 | B | 2024-06-21 00:00:00 |  |  |  |  |  |  | Ordre
54 | 378000 | 2025-01-20 00:00:00 | 2025-02-10 00:00:00 | C | 2024-12-23 00:00:00 |  |  |  |  |  |  | Ordre
55 | 2049689 | 2024-09-23 00:00:00 | 2026-06-30 00:00:00 | C | 2024-09-04 00:00:00 |  |  |  |  |  |  | Ordre
56 | 796732 | 2024-09-09 00:00:00 | 2026-01-30 00:00:00 | C | 2024-08-21 00:00:00 |  |  |  |  |  |  | Ordre
57 | 4700000 | 2024-07-01 00:00:00 | 2027-12-20 00:00:00 | C | 2024-06-10 00:00:00 |  |  |  |  |  |  | Ordre
58 | 392000 | 2025-01-13 00:00:00 | 2025-02-28 00:00:00 | A | 2024-12-20 00:00:00 |  |  |  |  |  |  | Ordre
59 | 1700000 | 2025-01-13 00:00:00 | 2025-02-28 00:00:00 | A | 2024-12-19 00:00:00 |  |  |  |  |  |  | Ordre
6 | 0 | 2025-01-02 00:00:00 | 2025-01-17 00:00:00 | B | 2024-12-06 00:00:00 |  |  |  |  |  |  | Ordre
60 | 959000 | 2024-12-09 00:00:00 | 2025-05-01 00:00:00 | A | 2024-11-26 00:00:00 |  |  |  |  |  |  | Ordre
61 | 125000 | 2025-01-13 00:00:00 | 2025-01-27 00:00:00 | A | 2024-12-05 00:00:00 |  |  |  |  |  |  | Ordre
62 | 79500 | 2025-01-27 00:00:00 | 2025-01-31 00:00:00 | A | 2024-11-11 00:00:00 |  |  |  |  |  |  | Ordre
63 | 513000 | 2025-01-02 00:00:00 | 2025-01-15 00:00:00 | A | 2024-11-29 00:00:00 |  |  |  |  |  |  | Ordre
64 | 2005340 | 2025-01-06 00:00:00 | 2025-06-06 00:00:00 | A | 2024-12-05 00:00:00 |  |  |  |  |  |  | Ordre
65 | 1 | 2025-01-13 00:00:00 | 2025-12-31 00:00:00 | A | 2024-10-23 00:00:00 |  |  |  |  |  |  | Ordre
66 | 555655 | 2025-01-15 00:00:00 | 2025-04-11 00:00:00 | A | 2024-11-19 00:00:00 |  |  |  |  |  |  | Ordre
67 | 98000 | 2025-02-17 00:00:00 | 2025-02-28 00:00:00 | A | 2024-12-11 00:00:00 |  |  |  |  |  |  | Ordre
68 | 294000 | 2024-11-18 00:00:00 | 2025-04-04 00:00:00 | A | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
69 | 472500 | 2024-11-04 00:00:00 | 2025-01-31 00:00:00 | A | 2024-10-31 00:00:00 |  |  |  |  |  |  | Ordre
7 | 300000 | 2025-01-13 00:00:00 | 2025-01-27 00:00:00 | C | 2024-12-17 00:00:00 |  |  |  |  |  |  | Ordre
70 | 398000 | 2024-12-09 00:00:00 | 2025-01-10 00:00:00 | A | 2024-11-20 00:00:00 |  |  |  |  |  |  | Ordre
71 | 500000 | 2025-02-03 00:00:00 | 2025-03-03 00:00:00 | A | 2024-11-25 00:00:00 |  |  |  |  |  |  | Ordre
72 | 123600 | 2024-11-11 00:00:00 | 2025-04-30 00:00:00 | A | 2024-10-28 00:00:00 |  |  |  |  |  |  | Ordre
73 | 137000 | 2024-08-05 00:00:00 | 2025-10-30 00:00:00 | A | 2024-04-10 00:00:00 |  |  |  |  |  |  | Ordre
74 | 0 | 2024-02-19 00:00:00 | 2025-11-28 00:00:00 | D | 2024-01-04 00:00:00 |  |  |  |  |  |  | Ordre
75 | 5084565 | 2024-05-02 00:00:00 | 2025-01-02 00:00:00 | D | 2024-03-15 00:00:00 |  |  |  |  |  |  | Ordre
76 | 1390542 | 2025-02-03 00:00:00 | 2025-03-28 00:00:00 | D | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
77 | 1069938 | 2025-02-03 00:00:00 | 2025-03-28 00:00:00 | D | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
78 | 608314 | 2025-01-20 00:00:00 | 2025-02-28 00:00:00 | D | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
79 | 511965 | 2025-01-06 00:00:00 | 2025-02-07 00:00:00 | D | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
8 | 1 | 2024-11-18 00:00:00 | 2024-12-20 00:00:00 | C | 2024-11-15 00:00:00 |  |  |  |  |  |  | Ordre
80 | 3227802 | 2024-12-02 00:00:00 | 2025-02-28 00:00:00 | B | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
81 | 1700285 | 2024-12-02 00:00:00 | 2025-02-21 00:00:00 | B | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
82 | 43084 | 2025-02-03 00:00:00 | 2025-02-07 00:00:00 | B | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
83 | 911106 | 2025-01-06 00:00:00 | 2025-02-21 00:00:00 | B | 2024-11-18 00:00:00 |  |  |  |  |  |  | Ordre
84 | 1070396 | 2024-11-04 00:00:00 | 2025-01-10 00:00:00 | B | 2024-09-30 00:00:00 |  |  |  |  |  |  | Ordre
85 | 1655100 | 2024-10-21 00:00:00 | 2025-01-10 00:00:00 | B | 2024-09-30 00:00:00 |  |  |  |  |  |  | Ordre
9 | 9309075 | 2024-09-09 00:00:00 | 2026-10-22 00:00:00 | C | 2024-09-09 00:00:00 |  |  |  |  |  |  | Ordre