Complex query question
 

Here's what I've got to do:

Column Row

Priority Rating 1, 2, or 3

CIA Rating (spread over three columns)
0, 1, 2, or 3 -
can be any combination of
three digits
(ex: 011, 111, etc)

Priority Validation ODD or EVEN

I need to count the number of records by country (Country names are located
in column D) where records with the following conditions meet:

1) # of records where Priority Validation ODD or EVEN is missing for
Priority Rating 3 Applications
2) # of records where CIA Rating 011 is missing a Priority Rating of 3
3) # of records where CIA Rating 111 is missing a priority Rating of 3

Can anyone help?