SOLVED

# Function to count Application

Copper Contributor

# Function to count Application

How do you count a number of entries when they do not have numerical values?

As an example, if I had a number of names listed on a sheet & I wanted to count how many names were on the sheet, what function would I use to achieve this?

2 Replies
best response confirmed by Kathyfromtheshire (Copper Contributor)
Solution

# Re: Function to count Application

If you want to count the number of non-blank cells, use COUNTA. Example:

=COUNTA(A2:A50)

If you want to count how many unique names there are (i.e. counting duplicate names only once), use COUNTA combined with UNIQUE. For example:

=COUNTA(UNIQUE(A2:A50))

# Re: Function to count Application

Dear Hans

Thank you so much for the assistance.

l tried it & it did exactly what I required.

I wasted two days trying to work it out.

You are a Godsend.

1 best response

Accepted Solutions
best response confirmed by Kathyfromtheshire (Copper Contributor)
Solution

# Re: Function to count Application

If you want to count the number of non-blank cells, use COUNTA. Example:

=COUNTA(A2:A50)

If you want to count how many unique names there are (i.e. counting duplicate names only once), use COUNTA combined with UNIQUE. For example:

=COUNTA(UNIQUE(A2:A50))