Formulas to Count Unique Text Values with Criteria in Excel!!
Tags: excelformula, excelformulas
Published: 2020-11-18 10:41:28

---
title: Formulas to Count Unique Text Values with Criteria in Excel!!
published: true
date: 2020-11-17 12:00:23 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-unique-text-values-with-criteria-in-excel/
---

In this tutorial, we will discuss the **Formulas used to count the unique text values from a range with criteria in Excel Office 365**. Let’s get started!!

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 text values with criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-unique-text-values-with-criteria.png)](https://geekexcel.com/formulas-to-count-unique-text-values-with-criteria-in-excel/formulas-to-count-unique-text-values-with-criteria/#main)<figcaption id="caption-attachment-17441">Formulas to count unique text values with criteria</figcaption>
## General Formula:

- To count unique text with criteria in Excel, use the below formula

**=[SUM](https://geekexcel.com/sum-function/)(–([FREQUENCY](https://geekexcel.com/how-to-use-excel-frequency-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(criteria,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(data,data,0)),[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(data)-ROW(data.first cell)+1)>0))**

## Syntax Explanations:

- **SUM** – The Excel **[SUM Function](https://geekexcel.com/sum-function/)** will add the values in the cells.
- **FREQUENCY** –  This function returns a frequency distribution which means the frequency of each value in a range. Read more on the [**FREQUENCY Function**](https://geekexcel.com/how-to-use-excel-frequency-function-in-office-365-with-examples/).
- **IF** – It will return one value for a TRUE result, and another for a FALSE result. Read more on the [**IF Function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/).
- **MATCH** – The **[MATCH Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** will locate the position of a lookup value in a row, column, or table.
- **ROW** – The **[ROW function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** returns the row number for reference.
- **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.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Plus operator (+)** – This symbol helps to add the values.
- **Criteria ** – It is the specific condition given in the worksheet.

## Example:

- In the below example, we will show how to count unique text with criteria.
- First, we give the input values in **Column C** and **Column D**.
- Then, enter the given formula in the formula bar section.
- After applying the formula, **Press (CTRL+SHIFT+ENTER) Keys**.
- Finally, it will display the result as shown below.

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

## Bottom-Line:

From this article, you can get to know the **Formula used for counting the unique text values from a range in Excel Office 365**. Hope that you like this article. If you have any **doubts/queries,** feel free to share it with us. 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 to Count Cells that contain either X or Y!!](https://geekexcel.com/excel-formulas-to-count-cells-that-contain-either-x-or-y/)**
- **[Formulas for Counting Cells that Contain Negative Values in Excel!!](https://geekexcel.com/formulas-for-counting-cells-that-contain-negative-values-in-excel/)**