Count Question

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

Guest

I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more than
once so I just want to count the number of customers not including the
duplicates.
This should be simple but I can't seem to figure it out.
 
say from B1 thru B100 with no blanks:

=SUM(1/COUNTIF(B1:B100,B1:B100)) entered with CNTRL-SHFT-ENTER
 
Here's another one that accounts for empty cells (not counted as a unique):

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
 
Back
Top