Count if one cell has a name in it and another column does not

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All - I'm using Office 2003, I have groups of names in column A and if
the name is repeated in a different group I have "Dup." in column B. I need
to count how many names are in column A that do not have "Dup." in column B.

Your help is appreciated! :)
Vera in Michigan
 
=COUNTIF(B2:B500,"<>Dup")


adapt to fit


or if there can be blanks in A

=SUMPRODUCT(--(A2:A500<>""),--(B2:B500<>"Dup"))
 
Thank you very much Peo! It worked beautifully!

Peo Sjoblom said:
=COUNTIF(B2:B500,"<>Dup")


adapt to fit


or if there can be blanks in A

=SUMPRODUCT(--(A2:A500<>""),--(B2:B500<>"Dup"))
Click to expand...
 
Back
Top