Intro Two Criteria Highs

This intro problem practices MAXIFS. MAXIFS returns the highest value only from rows where every listed condition is met. Update the output cells so each summary row finds the highest score that matches 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 MAXIFS details and syntax? Review the MAXIFS function guide first.

MAXIFS
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