I am trying to get a count of every time each person does not meet goal.
I've spent some time on this and my best attempt is:

COUNT(IF(($A$2:$A$11="XXX")*($D$2:$D$11C2:C11)*$G 2:G11<F2:F11*J2:J11<I2:I11)).
It doesn't work, of course, but I've spent some time creating chaos. Can
anyone help me with this? Below is an example of how the data might look:

A C D F G
I J
Name Goal Parts Made Goal Parts Made Goal Parts Made
XXX 8 7 5 8
20 14
YYY 3 4 7 6
5 6
XXX 9 10 6 5
25 23
ZZZ 5 8 12 10
15 14
YYY 9 5 22 22
18 19
ZZZ 50 45 16 18 24
25