Intro Team Totals

This intro problem practices SUMIF. SUMIF adds numbers from one range when matching cells in another range meet one condition. Update the output cells so each team row shows the total units for that team. See Examples

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

SUMIF
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