Please don't post more than once, stay in the original thread.
The regulars will find your post

As I posted to your other post you cannot use that function with ranges that
are not equal in size

You can try


=SUMPRODUCT((D4:D10="CR")*(MOD(COLUMN(G4:K10),3)0 )*(G4:K100))


or


=SUMPRODUCT((D4:D13="CR")*(G4:H130))+SUMPRODUCT(( D4:D13="CR")*(J4:K130))

--


Regards,


Peo Sjoblom

"Deb" wrote in message
...
=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