Excel Formulas to Count Cells that do not contain Errors!!
Tags: excelformula, excelformulas
Published: 2020-11-02 12:06:40

---
title: Excel Formulas to Count Cells that do not contain Errors!!
published: true
date: 2020-11-02 11:59:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-cells-that-do-not-contain-errors/
---

In this tutorial, you can learn the **Formulas to count cells that do not contain any errors in Excel Office 365**. We also guide you to know the basic syntax and explanations with a suitable example. Let’s get into this article!! 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 any errors](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-count-cells-that-do-not-contain-any-errors.png)](https://geekexcel.com/excel-formulas-to-count-cells-that-do-not-contain-errors/formulas-to-count-cells-that-do-not-contain-any-errors/#main)<figcaption id="caption-attachment-16729">Formulas to count cells that do not contain any errors</figcaption>

## General Formula:

- The following formula will help you to count the cells that do not contain any errors in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(–[NOT](https://geekexcel.com/how-to-use-not-function-in-microsoft-excel-365/)([ISERR](https://geekexcel.com/different-ways-to-iserr-function-in-excel-365/)(range)))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, this function will multiply the corresponding arrays or ranges and returns the sum of the products. Read more on [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **NOT** – It is used to reverse logical value. When given TRUE, NOT Function returns FALSE or vice versa. Read more on [**NOT Function**](https://geekexcel.com/how-to-use-not-function-in-microsoft-excel-365/).
- **ISERR** – The  Excel [**ISERR **** function**](https://geekexcel.com/different-ways-to-iserr-function-in-excel-365/) displays the output when the input cell contains #N/A then it will be FALSE Otherwise returns TRUE for any type of ERROR.
- **Range** -It represents an input range given in a worksheet.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – It is used to subtract two values.

## Example:

- In the below image, we give the input in **Column B**.
- Then enter the given formula in the formula bar section.
- Finally, we get the result in the selected **Cell E3**.

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

## Verdict:

From this article, we explained the **formulas for counting the number of cells that do not contain any errors in Excel Office 365** with the best example. Hope you like this article. If you have any queries, leave it in the below comment box. 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:

- **[Excel Formulas to Count the Cells Less than a Given Number!!](https://geekexcel.com/wp-admin/post.php?post=16409&action=edit)**
- **[Formulas to Count Cells Contains Equal Values or Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16324&action=edit)**