ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Data StreamCount cells with errors:0
Data Base
TypeCode
Num Row
2
#REF!Row num. with 1st error:0321#NULL!#N/A6
3
745Count errors type #DIV/0!:0#NUM!#DIV/0!#N/A
4
#DIV/0!Row with 1st error #DIV/0!:#N/A#DIV/0!#VALUE!#N/A
5
#NAME?#NAME?#REF!#N/A
6
#REF!987#NAME?#N/A
7
#NULL!#REF!#NUM!#N/A
8
779745#N/A#N/A
9
#N/A#DIV/0!#N/A#N/A
10
#NAME?#VALUE!#N/A
11
#REF!#VALUE!#N/A
12
#NULL!#VALUE!#N/A
13
779#VALUE!#N/A
14
#N/A#VALUE!#N/A
15
830#VALUE!#N/A
16
#DIV/0!
17
306https://exceltable.com/formula-example/how-to-count-errors-by-code
18
389
19
#REF!
20
#NULL!
21
219
22
666
23
321
24
533
25
#NULL!
26
#DIV/0!
27
378
28
112
29
#NULL!
30
431
31
#VALUE!
32
#REF!
33
#REF!
34
#VALUE!
35
745
36
#VALUE!
37
#DIV/0!
38
662
39
370
40
110
41
#NUM!
42
#REF!
43
759
44
#N/A
45
590
46
287
47
584
48
636
49
753
50
860
51
#NAME?
52
326
53
#N/A
54
#REF!
55
#NUM!
56
#N/A
57
#DIV/0!
58
#NUM!
59
450
60
523
61
#VALUE!
62
#NAME?
63
#NUM!
64
406
65
527
66
#N/A
67
#NULL!
68
708
69
985
70
#NUM!
71
892
72
844
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100