====== Microsoft Excel - Count - Count the number of errors in a range ======

Sample data:

<code>
1
2
#REF!
3
#REF!
5
</code>

----

===== Count the number of errors in a range =====

<code>
=SUM(IF(ISERROR(A1:A6),1))
</code>

returns 2.