Very often, you have to work with huge tables of data in Excel. It is a hard thing to cope with such a mess. In this lesson, you will learn how to count the number of errors in your sheet.

## The SUM IF ISERROR formula

To count the number of errors in Excel, you can use such a formula:

**{=SUM(IF(ISERROR(A1:E1000);1;0))}**

## An explanation

A1:E1000 - this is a range of your data. You can change this part of the formula to suit your worksheet.

Note: Remember that this is an array formula, so you should use the **CTRL + SHIFT + ENTER** key combination.

Note: The array formula counts all errors, not just specific error types.

Now you are aware of how many errors there are in your Excel spreadsheet.

## The COUNTIF formula

To count the number of errors in a range in Excel, you can use the COUNTIF formula. The COUNTIF formula allows you to count the number of cells within a range that meet a specified criteria.

Here's how you can use the COUNTIF formula to count the number of errors in a range:

- Select the cell where you want the count to appear.
- Type "=COUNTIF(", followed by the range that you want to count errors in.
- Enter a comma and type in the error type, such as "#N/A", "#VALUE!", or "#REF!" in quotation marks.
- Close the parentheses and press Enter.

Example: If you want to count the number of #N/A errors in the range A1:A10, the formula would be: =COUNTIF(A1:A10,"#N/A")

Note: You can use the same formula to count other error types by changing the error type in the formula.

In conclusion, the COUNTIF formula is a simple and efficient way to count the number of errors in a range in Excel. With either method, you can quickly get an accurate count of the errors in your data, making it easier to identify and correct them.