Question: How do I count unique and unique distinct values in a range, for example cells A1:D4?

Answer:

Formula in D8:

=SUM(IF(COUNTIF(tbl, tbl)=1, 1, 0)) + CTRL + SHIFT + ENTER

Formula in D9:

=SUM(1/COUNTIF(tbl, tbl)) + CTRL + SHIFT + ENTER

Named ranges
tbl (A1:D4)
What is named ranges?

Functions in this article:

COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition

SUM(number1,[number2],)
Adds all the numbers in a range of cells

This blog article is one out of twelve articles on the same subject "count unique and unique distinct".

• Count unique values in a column in excel
• Count unique distinct values in two columns in excel
• Count unique distinct values in three columns combined in excel
• Count unique and unique distinct values in a multicolumn range in excel
  
• Count unique values and unique distinct values in two ranges combined
  
• Count unique values and unique distinct values in three ranges combined in excel
• How to count unique combined column values
• How to count unique distinct records in a date range
  
• Count unique distinct records in a date range and a numeric range in excel
  
• Count unique distinct values in two columns with date criteria in excel
  
• Count unique distinct months in excel
• Count duplicate distinct values in a column in excel

Related posts:

1. Count unique distinct records in a date range and a numeric range in excel
2. Count unique distinct months in excel
3. Count unique distinct values using date criteria in a range in excel
4. Count unique distinct text values in a range in excel
5. Count unique records by date in excel
6. Count unique values in two lists combined in excel
7. How to count unique distinct occurrences for each date in excel