Count Question

S

Secret Squirrel

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

Gary''s Student

say from B1 thru B100 with no blanks:

=SUM(1/COUNTIF(B1:B100,B1:B100)) entered with CNTRL-SHFT-ENTER
 
T

T. Valko

Here's another one that accounts for empty cells (not counted as a unique):

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