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

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

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

=COUNTIF(B2:B500,"<Dup")


adapt to fit


or if there can be blanks in A

=SUMPRODUCT(--(A2:A500<""),--(B2:B500<"Dup"))



--
Regards,

Peo Sjoblom




"Vera Lemon" wrote in message
...
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

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

Thank you very much Peo! It worked beautifully!

"Peo Sjoblom" wrote:

=COUNTIF(B2:B500,"<Dup")


adapt to fit


or if there can be blanks in A

=SUMPRODUCT(--(A2:A500<""),--(B2:B500<"Dup"))



--
Regards,

Peo Sjoblom




"Vera Lemon" wrote in message
...
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