Monthly Deals Quota Check

Update the output cells so that each row displays "Met" if the number of deals for the table in columns F:I that are "Closed" for that rep during the month specified by the single date in B9 is greater than or equal to that rep's target in column C. Otherwise, display "Missed". The count must include deals only on dates from the first day of the month through the last day of the same month as B9. 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