Intro Two Criteria Means

This intro problem practices AVERAGEIFS. AVERAGEIFS averages values only when every listed condition is met. Update the output cells so each summary row averages only the scores that match both its region in column B and its status in column C. See Examples

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

Need help with AVERAGEIFS details and syntax? Review the AVERAGEIFS function guide first.

AVERAGEIFS
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