Excel Formulas to Count the Cells that do not contain many Strings!!
Tags: excelformula, excelformulas
Published: 2020-11-03 09:03:33

---
title: Excel Formulas to Count the Cells that do not contain many Strings!!
published: true
date: 2020-11-03 08:17:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-cells-do-not-contain-many-strings/
---

Here, we will show the **Formulas to count the number of cells that do not contain many Strings or Values in Excel Office 365**. You can also learn the basic syntax and explanations from this article. 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 cells that do not contain many strings](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/EXCEL_qqmTUIrIFe.png)](https://geekexcel.com/?attachment_id=16803#main)<figcaption id="caption-attachment-16803">Formulas to count cells that do not contain many strings</figcaption>
## General Formula:

- To count the number of cells that do not contain many strings in Excel, use the below formula.

**=[SUM](https://geekexcel.com/sum-function/)(1-([MMULT](https://geekexcel.com/use-mmult-function-in-microsoft-excel-365-simple-methods/)(–([ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)([TRANSPOSE](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/)(exclude),data))),[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(exclude)^0)>0))**

## Explanations for Syntax:

- **SUM** – The [**SUM Function**](https://geekexcel.com/sum-function/) will add the two or more values and print the value in the output cell.
- **MMULT** – In Excel, this function helps to return the matrix product of two arrays. Read more on **[MMULT Function](https://geekexcel.com/use-mmult-function-in-microsoft-excel-365-simple-methods/)**.
- **ISNUMBER** – The[  **ISNUMBER**   **function**](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/) returns TRUE when a cell contains a number, and FALSE if there will not be a number.
- **SEARCH** – The Excel[**SEARCH function **](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)returns the location of one text string inside another.
- **TRANSPOSE** – This Function will change the orientation of a given range or array. Read more on the **TRANSPOSE Function**.
- **ROW** -It is used to return the row number for reference. Read more on **[ROW Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)**.
- **Exclude** – It is the criteria to count the cells which is not equal to many strings.
- **Data** -It represents an input range given in a worksheet.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Minus operator (-)** – This symbol is used to subtract any two values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below image, we will show the formula to count the cells that do not contain many values.
- You need to give the input range.
- Then, enter the given formula in the formula bar section.
- After that, **Press (CTRL + SHIFT + ENTER) keys,** it will display the result as shown below.

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

## Conclusion:

In this tutorial, you can get to know the **formulas for counting the number of cells that do not contain many strings in Excel**. Hope that this article is useful to you. Drop your feedback in the below section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Formulas for Counting the Cells that are Blank in Excel Office 365!!](https://geekexcel.com/formulas-for-counting-the-cells-that-are-blank-in-excel/)**
- **[Excel Formulas for Counting Cells that Contain Odd Numbers!!](https://geekexcel.com/excel-formulas-for-counting-cells-that-contain-odd-numbers/)**
- [**Formulas for Extracting Substring Between Two Texts in Excel 365!!**](https://geekexcel.com/formulas-for-extracting-substring-between-two-texts-in-excel-365/)