Compounded Factors

crown

Update the output cells so that each row displays the mathematical product of all factors with a matching project and region from the table in columns F:H. If there are no matching factors, 1 should be displayed. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

PRODUCT FILTER IFERROR
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
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