Q3_Forecast_FINAL_v7 (2).xlsxSheet 1 of 4
B7fx=IFERROR(VLOOKUP(B7,Regions!$A:$D,4,0)*SUMIF($B:$B,B7,C:C),0)
A
B
C
D
E
F
G
H
I
J
K
L
1
A-0401
DE
76,350
-64,877
20,022
25,074
32,605
58,120
=SUM(C4:H4)
16.7%
TRUE
EUR
2
A-0410
NL
52,278
-33,172
72,800
87,087
-33,247
3,836
=SUM(C5:H5)
-2.9%
TRUE
x7
3
A-0417
SE
51,799
23,592
41,536
-68,547
4,166
36,653
=SUM(C6:H6)
29.8%
TRUE
EUR
4
A-0423
NL
46,552
49,246
56,046
14,276
-63,134
3,386
=SUM(C7:H7)
21.9%
TRUE
EUR
5
A-0430
IT
-58,530
15,536
80,728
86,355
82,155
55,031
=SUM(C8:H8)
17.3%
TRUE
EUR
6
A-0438
PL
56,873
9,736
64,467
16,923
33,055
-1,059
=SUM(C9:H9)
13.2%
FALSE
EUR
7
A-0446
AT
36,608
58,962
34,287
29,944
45,634
57,248
=SUM(C10:H10)
9.9%
TRUE
x7
8
A-0452
NL
-64,821
50,157
62,692
-76,457
65,623
72,927
=SUM(C11:H11)
24.0%
TRUE
EUR
9
A-0460
PL
59,133
54,177
-71,095
-1,829
48,616
38,128
=SUM(C12:H12)
12.1%
TRUE
EUR
10
A-0464
ES
43,840
30,102
88,342
19,428
74,732
2,946
=SUM(C13:H13)
13.0%
TRUE
x7
11
A-0473
ES
63,243
46,382
6,612
62,696
78,650
3,027
=SUM(C14:H14)
27.6%
FALSE
EUR
12
A-0478
ES
42,598
67,538
25,864
58,045
89,198
-50,821
=SUM(C15:H15)
22.1%
#REF!
x7
13
A-0484
SE
23,938
49,703
48,234
9,186
88,935
22,182
=SUM(C16:H16)
24.5%
FALSE
EUR
14
A-0493
PL
68,137
24,810
11,655
72,624
60,481
-80,088
=SUM(C17:H17)
8.9%
FALSE
x9
15
A-0500
DE
34,830
76,267
79,501
32,548
68,923
21,693
=SUM(C18:H18)
2.9%
TRUE
x7
16
A-0508
FR
18,027
9,417
-40,170
8,898
43,405
75,413
=SUM(C19:H19)
-8.8%
FALSE
x4