Home MS Excel TutorialExcelTips and Tricks Counting the number of errors in the sheet

Counting the number of errors in the sheet

by Easy Excel Tutorials

Counting The Number Of Errors In The Sheet

Very often you have to work with huge tables of data in Excel. There is a hard thing to cope with such a mess. In this lesson you will teach yourself how to count a number of errors in your sheet. To count number of errors in Excel you can use such a formula:




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


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


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


You can download the Template here – Download

You may also like