Spreadsheet: 888841d1739447899-using-if-formula-for-each-instance-in-sumproduct-table_test
Sheet: Sharepoint

Project number | Order sum | Start | Finish | Department | Order date | Status |  | Department | A | Order Sum | B | Order Sum | C | Order Sum | D | Order Sum
 |  |  |  |  |  |  | For 2025 >>>>> | Total by Dept | Project |  | Project |  | Project |  | Project
 |  |  |  |  |  |  |  |  | 2 |  | 12 |  | 8 |  | 11
 |  |  |  |  |  |  |  |  | 3 |  | 13 |  | 9 |  | 37
 |  |  |  |  |  |  |  |  | 4 |  | 14 |  | 44 |  | 74
 |  |  |  |  |  |  |  |  | 5 |  | 15 |  | 49 |  | 75
 |  |  |  |  |  |  |  |  | 58 |  | 16 |  | 50 |  | 76
 |  |  |  |  |  |  |  |  | 59 |  | 17 |  | 51 |  | 77
 |  |  |  |  |  |  |  |  | 60 |  | 18 |  | 52 |  | 78
 |  |  |  |  |  |  |  |  | 61 |  | 19 |  | 54 |  | 79
 |  |  |  |  |  |  |  |  | 62 |  | 20 |  | 55
 |  |  |  |  |  |  |  |  | 63 |  | 21 |  | 56
 |  |  |  |  |  |  |  |  | 64 |  | 22 |  | 57
 |  |  |  |  |  |  |  |  | 65 |  | 23
 |  |  |  |  |  |  |  |  | 66 |  | 24
 |  |  |  |  |  |  |  |  | 67 |  | 25
 |  |  |  |  |  |  |  |  | 68 |  | 26
 |  |  |  |  |  |  |  |  | 69 |  | 27
 |  |  |  |  |  |  |  |  | 70 |  | 28
 |  |  |  |  |  |  |  |  | 71 |  | 29
 |  |  |  |  |  |  |  |  | 72 |  | 30
 |  |  |  |  |  |  |  |  | 73 |  | 31
 |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  |  |  |  | 85
1 | 10000 | 2024-12-13 00:00:00 | 2024-12-31 00:00:00 | A | 2024-12-13 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
3 | 45000 | 2024-12-06 00:00:00 | 2024-12-31 00:00:00 | A | 2024-12-06 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
5 | 6000 | 2024-11-20 00:00:00 | 2024-11-30 00:00:00 | A | 2024-11-20 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
7 | 300000 | 2025-01-13 00:00:00 | 2025-01-27 00:00:00 | C | 2024-12-17 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
9 | 9309075 | 2024-09-09 00:00:00 | 2026-10-22 00:00:00 | C | 2024-09-09 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
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
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
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
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
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
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
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