====== Microsoft Excel - SUM - Sum with NA in range ======

Sample data:

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

----

===== Get the sum =====

<code>
=SUM(IFERROR(A1:D6,""))
</code>

returns 11.

----

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

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

returns 2.