Forum Discussion
Count the number of clients in a column
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 ...
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 Oooops. Yes, I forgot the "A" after COUNT, Sorry,
Use COUNTA instead of COUNT (the latter counts numbers only):
=COUNTA(UNIQUE(clients))
