Working with large and very large data sets, you may find that an error will creep into your calculations. To avoid the tedious scanning of thousands of records for verification before sending a report or analysis to your supervisor, I will describe to you how you can avoid it.
Array formulas come in handy. We will use the fact that Excel interprets each logical value as a number = 1 for true values, and false is represented by a digit = 0
Function structure:
{= sum (or.error ( A1: C50 ))}
With this function, all cells containing an error will be counted.
Now, a brief analysis of the functions:
For each erroneous cell the function "if.error" will return the value "True", which in numerical notation is equivalent to the digit 1. So for each cell with an error we will get 1, to find out the total number of errors I use the "sum" function. I run the given record using the array function - because I am performing an operation on a range of data and I want to obtain a collective result in one cell.
This is how I get the number of error returning cells (as a result of the enumerations stored in them)