Count only data within a line break (alt-enter) with specific criteria in adjacent column

Hi everyone. I am trying to determine a formula that would count how many times a person is noncompliant based on my data, which consists of a name (within a line break amongst other names) and an adjacent column stating "Yes" or "No" (also within a line break). I do not want to use a VBA or macro, and am assuming it will end up being an array formula or a method that transfers the line breaks to individual rows. I have attached an example of what my data looks like and what I am looking for. Thanks in advanced for taking the time to help me.

Yeah this is pretty foul data haha.
I tried a few ways but I would resort to VBA to solve this, as I cant come up with a clever way to find the line breaks that isn't absurdly complicated.


What is the max number of "Missing"s a cell could have?

I started playing with this yesterday, and I think I might have cracked it... take a look at sheet2 of my attachment and see if it does the trick. The formula in D2:K60 parses your (horrific!) data into name/compliance pairs, then the table in M:N counts based on that data. Once you have all of your names in the table in column M, all you would need to do is enter/update new data in columns A and B, and everything else should adjust accordingly. I tried entering some additional names in column M to test it out, and it appears to hold up. You could easily fill the ugly formula in D2:K60 down to accommodate more rows, if necessary. Similarly, you could insert more columns after K and fill it right if you have more than 8 people working in one shift(?)/box. Give it a look, see if it helps?