Team Bonus Window

Update the output cells so that each listed team displays whether it earns a bonus. For each team, total all matching sales from the sales table in columns H:J where the team name matches and the sale date falls on or between that row's start and end dates. If the total meets or exceeds the target, display "Bonus". Otherwise, display "None" 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