Count the number of clients in a column

Occasional Visitor

I'm sure there is an easy calculation to this question but for the life of me I can't figure it out.  

 

I am trying to figure out how many clients are coming to an event.  All I need is a code to count each client.  I know that I can do this under the Data/Subtotal function, but I just need a total of companies coming.  

Admissions 
WLT CodeClients
AMERClaimChoice Administrators
AMERClaimChoice Administrators
AMERClaimChoice Administrators
PRCA Preferred Care
PRCA Preferred Care
IMCSRedbridge
IMCSRedbridge
PIMAPima County
PIMAPima County
  
  
  
# Clients 
5 
4 Replies

@ShelleyVan7990 Since you tag you post with Office365, you should have UNIQUE functions, like this:

 

= COUNT(UNIQUE(clients))

 

where "clients" refers to the column/range where the client names are listed.

 

That would be 4 in your example, not 5

It is coming up 0 not 4

@ShelleyVanEtten 

Use COUNTA instead of COUNT (the latter counts numbers only):

 

=COUNTA(UNIQUE(clients))

@ShelleyVanEtten Oooops. Yes, I forgot the "A" after COUNT, Sorry,