Actually the range I am trying to look at is G4:G10/H4:H10/J4:J10/and K4:K10.
Each column has a different responsibility held by the person and the
responsibilites are assigned to varying functions defined by what they fall
under Compliance, Underwriting, and Other.

As I am reading through here I am wondering if SUMPRODUCT is not what I
need. Any help would be appreciated.

Thanks.
--
Deb


"Deb" wrote:

=COUNTIFS(G$4:H$10,"0",D$4:D$10,"CR")+COUNTIFS(J$ 4:K$10,"0",D$4:D$10,"CR")

The above calculation does not work. Can anyone help me? I need to count
the number of exceptions in a range of columns skipping column "I" if the
persons initials in a range in column "D" equals their initials.

Thanks.
--
Deb