Forum Discussion
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?
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))
2 Replies
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))
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.
