Totals by SKU and Region

crown

Update the output cells so each row shows the total units for transactions that match both the SKU in column B and the Region Key derived from column C. Transactions are displayed on the right table in columns F:H. The Region Key is the first letter of the Region name (North → N, East → E, South → S, West → W). See Examples

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

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