Thread: COUNTIF help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb Deb is offline
external usenet poster
 
Posts: 102
Default COUNTIF help

=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