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

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
 
P

Peo Sjoblom

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


adapt to fit


or if there can be blanks in A

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

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula for multiple countifs 4
count unique records 14
Dup check 2 columns - need it to delete correct one 5
Sumif or Sumproduct? Maybe neither? 1
Excel Function??? 2
Count columns that meet criterias 3
count values in a range of cells depending on value in adjacent ce 1

Top