If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

However, things get a little more intricate if your column contains text entries. If you were to use the above function combination for this, it would only count the rows that feature numbers.