Group Score Flag

crown

Update the output cells so that each group's flag displays "High" if the average score for that group, based on all matching rows in the student table in columns E:G, is greater than or equal to 70. Otherwise, display "Low". See Examples

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

AVERAGEIF IF
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