The formula returns the number of "Missing Element" entries for rows that have the specified country and the value "UNRESOLVED"
Isn't that what you asked for.
Using your example the formula I proposed returned the number 3.
What happened when you used the formula.
You say how many "Missing Elements" there are from the ones that meet that criteria.
Does this mean that you are not looking for the term "Missing Element" , but are looking for other words - if so you need to specify what is being counted.