Count the number of errors in range

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 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.

count number of errors

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