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?

1)try a sumproduct
=sumproduct(--(Countylist=county),--(priorityVlist=""),--(priorityRlist=3))
2)
=sumproduct(--(countylist=county),--(Clist=0),--(Ilist=1),--(Alist=1),--(priorityRlist<3))
3) same as 2) except(Clist=1)

"Stacy" wrote:

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?