Formulas for Counting Unique Values in a Range with COUNTIF in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-18 10:41:58

---
title: Formulas for Counting Unique Values in a Range with COUNTIF in Excel!!
published: true
date: 2020-11-17 12:03:52 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-unique-values-in-a-range-with-countif-in-excel/
---

In this article, we will explain the **formulas for counting the unique values in a range with COUNTIF Function in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count unique values with COUNTIF Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/EXCEL_6yMebqRvvf.png)](https://geekexcel.com/formulas-for-counting-unique-values-in-a-range-with-countif-in-excel/excel_6ymebqrvvf/#main)<figcaption id="caption-attachment-17464">Formulas to count unique values with COUNTIF Function</figcaption>
## General Formula:

- To count unique values in a range with COUNTIF Function, use the below formula.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(1/COUNTIF(data,data))**

## Syntax Explanations:

- **SUMPRODUCT** – This function will multiply the corresponding array or range and returns the sum of the products. Read more on the **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)**.
- **COUNTIF** – In Excel, this function will help to count the cells that match a single condition or criteria.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Data** – It represents the input range from your worksheet.
- **Division (/)** – It is used for dividing values or numbers.

## Example:

- Let’s consider the below image, to count unique values in a range.
- First, you need to give input.
- In the below image, we will give the input in **Column C**.
- Then, enter the given formula in the formula bar.
- After applying the formula, we will get the result in **Cell G3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-39.png)<figcaption id="caption-attachment-17462">Example</figcaption>

## Wind-Up:

This page describes the **formulas used to count the unique values in a range using  COUNTIF Function in Excel Office 365**. Hope that this article is useful to you. Kindly, leave your valuable **feedback** in the below comment box. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas for Counting the Unique Numeric Values in a Range!!](https://geekexcel.com/excel-formulas-for-counting-the-unique-numeric-values-in-a-range/)**
- **[Formulas to Extract Numbers From Mixed Text String with Function!!](https://geekexcel.com/formulas-to-extract-numbers-from-mixed-text-string-with-function/)**
- **[Formulas for Counting the Rows that Contain Specific Values in Excel!!](https://geekexcel.com/formulas-for-counting-the-rows-that-contain-specific-values-in-excel/)**
- [**Excel Formulas to Count the Paired Items from a Listed Combination!!**](https://geekexcel.com/excel-formulas-to-count-the-paired-items-from-a-listed-combination/)