Count the number of clients in a column

[ShelleyVan7990]

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 Code	Clients
AMER	ClaimChoice Administrators
AMER	ClaimChoice Administrators
AMER	ClaimChoice Administrators
PRCA	Preferred Care
PRCA	Preferred Care
IMCS	Redbridge
IMCS	Redbridge
PIMA	Pima County
PIMA	Pima County
# Clients
5

[#2]

@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

[#3]

It is coming up 0 not 4

[#4]

@ShelleyVanEtten 

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

=COUNTA(UNIQUE(clients))

[#5]

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